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.





at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...

  • Oracle Integration Cloud Service(OICS) links
    Please find the following links for OIC hands on and relevant information: Oracle Integration Cloud Introduction | Benefits | Services offer...
  • 12c SOA - how to create csf-key
    Credential Store Framework (CSF) is used in OWSM to manage the secure credentials. CSF provides a way to store, retrieve, and delete cred...
  • 12c OSB Throttling
    What is Throttling: Throttling is termed as "regulate the flow". Oracle Service Bus has throttling feature and by using that f...