Sunday, January 30, 2022

OIC - Merge two different schema files into a single CSV file

What :  We will read 2 csv files having different schemas and marge them into a single final csv file.






Implementation Steps:

  • Create a FTP connection and create an Orchestrated integration.
  • Read 1st file using ftp connection and 1st CSV file schema.

  • Write the file in the Stage location with the same 1st CSV schema and map the read file.

  • Read the 2nd file using FTP connection and 2nd CSV file schema.

  • Write file into a stage location with the 2nd CSV schema. Keep the same file name and location. And also, keep Append to existing file checked in and map the read 2nd file.

  • Write the both marged file into a location using FTP connection.

No comments:

Post a Comment

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...