Load single file to multiple targets by specific columns

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 target

81-200 columns:2nd target


How can I split that single COBOL file data into two data files and How can I load that data using Informatica.


Thanks in Advance

Questions by GeekAdmin   answers by GeekAdmin

Showing Answers 1 - 3 of 3 Answers

Sravan Kumar

  • Dec 21st, 2006
 

USE NORMALIZER TRANSFERMATION.

  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