Sunday, October 17, 2021

ODI 12c - Loading Flat file to SQL table

Here, we will read a comma separated csv file and sends data to target Oracle table.

Steps:

File format:


Step1: Topology - Physical Architecture - File - File Generic



Step2: File data server - New Physical schema


Step3: Provide directory



Step4: Create new logical schema



Step5: Designer - new model folder - new model




Step6: provide all details like name, technology and logical schema name


Step7: create new data store










Step8: map and provide LKM and IKM and flow control as false.





No comments:

Post a Comment

Featured Post

OIC XSLT: Execute Only When At Least One Field Has Value and None Are Blank

๐Ÿ”ท OIC XSLT: Validate Fields Before Executing Logic ๐Ÿ”น Requirement Fields: field1, field2, field3, field4, field5 ✔ Execute only when: At le...