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 can I use XSLT functions to remove leading zeros from numeric and alphanumeric fields?
To remove leading zeros from an numeric field in Oracle Integration Cloud (OIC) using XSLT, you can Use number() Function The number() funct...
-
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. ...
-
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 extract the data from HCM and then download the data from UCM uaing Flow Actions Service and Generic Soap Service To... -
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 see how we can download the import Payables Invoices report. That is we will download report equivalent .xml file w... -
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... -
Credential Store Framework (CSF) is used in OWSM to manage the secure credentials. CSF provides a way to store, retrieve, and delete cred...
No comments:
Post a Comment