i have a session which creates a file every time when i runs
the session, but it replaces the first file with second file,i
want to append the second file follwed by first file when i
runs the session,how to achieve this?



i have a session which creates a file every time when i runs the session, but it replaces the firs..

Answer / priyank

select the option "append if exists" in the session
properties.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,


Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?

1 Answers  


in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,


a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,


my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,






How many ways are there to do 'remove duplicate records in informatica'?

0 Answers  


can we override a native sql query within informatica? How do we do it?

0 Answers  


Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,


in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,


how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,


Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,


Can we update the data in flat file using update strategy?

3 Answers  


Categories