How to append records in flat file using Informatica?For eg : In Datastage we can append the records in flat file(sequential file) using the options i) overwrite the existinf file.ii) Append the existing file.

Questions by thiyagarajanc   answers by thiyagarajanc

Showing Answers 1 - 3 of 3 Answers

sam

  • Aug 10th, 2006
 

It is an interesting site and looks like it is a reservoir of questions.

I would like to post some questions and also reply to questions based on my experience.

  Was this answer useful?  Yes

promila

  • Jul 17th, 2007
 

HI ,

We can use /n as a delimiter to append data at the bottom and also checking the option - append in the workflow monitor . but i am not clear can we append data at the top .
One way is to create  a new file add the text and the append the origional file to this new file and then rename . Is there any more efficient way ?

Regards
Promila

dl_mstr

  • Jan 2nd, 2008
 

write a post_session command in the session.
For example :
COPY C:PreviousFinaloutput.csv+C:newflatfilerecords.csv C:PreviousFinaloutput.csv

  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