How do you add and delete header , footer records from flat file during load to oracle?

Showing Answers 1 - 1 of 1 Answers

Abhishek

  • Sep 21st, 2007
 

We can add header and footer record in two ways.

1) Within the informatica session we can sequence the data as such that the header flows in first and footer flows in last. This only holds true when you have the header and footer the same format as the detail record.

2) As soon as the sesion to generate detail record file finishes we can call unix script or unix command  through command task which will concat the header file detail file and footer file and generrate the required file

  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