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

use 2 rank transformations, 1st one with top1 and 2nd one with bottom1 and connect them to 2 instances of target..

Is This Answer Correct ?    3 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of olap? Give an example?

564


What does cheating measurement mean?

602


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4793


Write the different tools in the workflow manager?

577


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

642






What do you mean by enterprise data warehousing?

652


What is sequence generator transformation in informatica?

627


How union transformation is used?

595


Which transformation should we use to normalise the COBOL and relational sources?

748


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1483


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

557


What is the difference between Active and Passive transformation?

640


What are the reusable transformations?

704


What are batches?

623


What are the differences between a connected lookup and unconnected lookup?

654