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
Types of encryption techniques
There are several types of encryption techniques used to secure data, each with its own use case and strengths: 1. Symmetric Encryption Us...
-
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 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 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 demonstrate the detailed implementation steps for AP Invoice FBD Import from polling the file from source >> cr...
-
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... -
UseCase: While mapping the elements in the mapper using XSD structure of the file contents, getting below 2 types of translation errors: Err... -
Usecase: Here, we will see how we can download the import Payables Invoices report. That is we will download report equivalent .xml file w... -
Usecase: Here using ess job tables - ESS_request_history and ESS_request_property, we will fetch the latest succeeded processstart data as l...
No comments:
Post a Comment