Sign Up Login


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

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

Question Posted / natrajdreams

Answers were Sorted based on User's Feedback



Hi , Please help how to achieve the following scenario. I have a source table like this. Ro..

Answer / rakesh

To append the data, Union Transformation is required. Both sources have same layout, they are input to Union Transformation and the desired output can be obtained.

Is This Answer Correct ?    0 Yes 0 No

Hi , Please help how to achieve the following scenario. I have a source table like this. Ro..

Answer / harleen

The question needs to be corrected.I think there are 3 rows already in the target and only one row has to be inserted.
The same can be done by 2 ways

1)Update strategy (Update as Insert)

2)Dynamic lookup

Is This Answer Correct ?    1 Yes 2 No

Hi , Please help how to achieve the following scenario. I have a source table like this. Ro..

Answer / abhinaw prakash

You can implement the same using SCD 1.

Please let me know if you have any doubt.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

How many ways are there to create ports?

0 Answers   Informatica,

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,

How can you complete unrcoverable sessions?

1 Answers  

how to load only the first and last record of a flat file into the target?

8 Answers   CTS,

how can we use sorter transformation in joins?

5 Answers   IBM,

What are Business Components in Informatica?

1 Answers  

what are the settiings that u use to cofigure the joiner transformation?

2 Answers  

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

Difference between task flow and linear task flow

0 Answers  

What do you mean by filter transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories