i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .

Answer Posted / rakesh

Hi Chandrasekar,

My intension was to specify the column that is generated using sequence generator as RANK PORT. So no matter of sorting..

Thanks.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How are indexes created after completing the load process?

1264


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

876


How to go to the older version for a mapping?

834


what is the size of your data warehousing?

1883


What is the need of etl tools?

862


How can you define user defied event?

843


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1408


What is the fact table?

806


What is the Rank index port in Rank transformation?

874


Is it possible to revert a global repository to local one and why?

882


How to load a Dimension ? and how to load a fact table?

1166


what is SDLC way of code development?

1797


Differences between version 7.x and 8.x.

1667


Do you find any difficulty while working with flat files as source and target?

905


Explian the Process of deployment groups in informatica

842