1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / ameen


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

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,

What are active and passive transformations?

0 Answers   Informatica,

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

1 Answers   IBM,

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  




how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

Enlist the differences between database and data warehouse.

0 Answers  

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

For more Informatica Interview Questions Click Here
Categories