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

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,

How does the session recovery work.

1 Answers  

How do you recover rows from a failed session

1 Answers  




Explain factlessfact table with scenario

1 Answers   HCL,

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  

What is data merging, data cleansing and sampling?

6 Answers   Satyam,

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

0 Answers  

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,

who to split dimentions into sub dimention

3 Answers   Wipro,

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,

For more Informatica Interview Questions Click Here
Categories