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 / abhinaw prakash

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is target load order?

805

What are session parameters ? How do you set them?

1377

What are the types of presistent cache in look up tr.

1551

What are connected or unconnected transformations?

628

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

695




Differentiate between source qualifier and filter transformation?

1000

How to extract sap data using informatica? What is abap? What are idocs?

560

Explain informatica architecture - version 8 / 9

669

What differs when we choose the sorted input for aggregator transformation?

571

How might one distinguish in the case of mapping is right or not without associating session?

640

What are the types of lookup transformation?

631

How to elaborate powercenter integration service?

650

What is the procedure for creating independent data marts from informatica 7.1?

566

Different qualification between a related rotate toward the sky and isolates look upward?

556

What is target designer and target load order?

655