How to load only the first and last record of a flat file into
the target?

Answer Posted / yaseen

After SQ place 2 Rank T/R and a reusable sequence generator T/R having start value 1. In 1st Rank give the top 1 and in 2nd Rank set bottom 1

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the various types of transformation?

646


Partition, what happens if the specified key range is shorter and longer

2031


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

4793


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1690


What is mapping debugger?

574






What is the Process to creating lookup transformation in informatica

589


What are the features of complex mapping?

651


What is a pre-defined event and user-defined event?

581


How many numbers of sessions can one group in batches?

625


Plz can any one say me how to get the informatica certification materials and dumps

1602


What is the difference between router and filter?

651


What is a standalone command task?

662


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1861


how many types of dimensions are available in informatica?

565


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

641