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 / harleen

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by channel change?

543

Differentiate between sessions and batches?

574

What is lookup change?

618

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7767

How to convert multiple rows to single row (multiple columns) in informatica

899




Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

656

Make a note of the quantity vaults made in informatica?

560

What is expression transformation?

637

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1535

How to improve the performance of a session using sorter transformation?

688

Difference between Data and Index Caches?

660

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

629

What is the difference between stop and abort in informatica

664

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

697

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

626