Hi, I have a COBOL file and contains 500 records of sample data.It contains 200 columns.How can I split that file in Informatica?Like 1st file 1-80 columns and 2nd file 81-200 columns.Then I want load that data using Informatica.The Target are Oracle tables.1-80 columns: 1st target81-200 columns:2nd targetHow can I split that single COBOL file data into two data files and How can I load that data using Informatica.Thanks in Advance

  • Interview Candidate
  • 2
  • 4495

Showing Answers 1 - 2 of 2 Answers

Sharad

  • Jan 17th, 2007
 

Createa a temp stage table, load all the columns in it. The extract all columne from staging table and populate both tgt tables as you want.
Cheers.
Sharad

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions