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 - Padding leading zeros to a number field using xslt format-number()
In many payment-related integrations, credit card numbers often arrive as plain numeric strings. For security and compliance—and to meet tar...
-
OIC interview Q & A: 1. FBDI approach with an example https://soalicious.blogspot.com/2022/02/oic-erp-supplier-bulk-import-and.html 2. ...
-
Please find the following links for OIC hands on and relevant information: Oracle Integration Cloud Introduction | Benefits | Services offer...
-
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 demonstrate the detailed implementation steps for AP Invoice FBD Import from polling the file from source >> cr...
-
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... -
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... -
In Oracle Integration Cloud (OIC), the most commonly used XSLT functions are primarily focused on transforming, filtering, and manipulating ...
-
Reasons to use Projects: Build, Manage and Monitor in one place. Manage integrtaion releases. Control access with RBAC. Use and customize pr... -
Usecase: Here, we will see how we can download the import Payables Invoices report. That is we will download report equivalent .xml file w...
No comments:
Post a Comment