Here, we will read a comma separated csv file and sends data to target Oracle table.
Steps:
File format:
Sunday, October 17, 2021
ODI 12c - Loading Flat file to SQL table
Subscribe to:
Post Comments (Atom)
Featured Post
OIC - How to Retrieve Email Attachments Using Microsoft Graph API: Automating Payment File Processing
Retrieving Email Attachments Using Microsoft Graph API: Automating Payment File Storage in Object Storage Use Case: A finance team needs t...
-
Please find the following links for OIC hands on and relevant information: Oracle Integration Cloud Introduction | Benefits | Services offer...
-
OIC interview Q & A: 1. FBDI approach with an example https://soalicious.blogspot.com/2022/02/oic-erp-supplier-bulk-import-and.html 2. ...
-
Stage or vfs or virtual file system is a temporary location in the oic local file system which stores temporary files required for processin... -
Usecase: Here, we will extract the data from HCM and then download the data from UCM uaing Flow Actions Service and Generic Soap Service To... -
UseCase: Here, we will show you how to split an input, received as comma separated string values( here, emails) into array of values using c... -
Usecase: Here, we will see how we can download the import Payables Invoices report. That is we will download report equivalent .xml file w... -
What is Throttling: Throttling is termed as "regulate the flow". Oracle Service Bus has throttling feature and by using that f... -
Usecase: Here, we will demonstrate the detailed implementation steps for AP Invoice FBD Import from polling the file from source >> cr...
-
UseCase: While mapping the elements in the mapper using XSD structure of the file contents, getting below 2 types of translation errors: Err... -
In OIC Generation 2, we can also read file in segments or chunks using stage action but the chunk size is default limited to 200 records whi...
No comments:
Post a Comment