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

Enlist the tasks for which source qualifier transformation is used.

582


Design a mapping to load the cumulative sum of salaries of employees into target table?

889


What are the new features of informatica 9.x at the developer level?

600


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3319


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9162






Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1584


What is the difference between writing a joiner query in ANSI style and THETA style?

1915


what are the Methods For Creating Reusable Transformations?

646


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

642


What is dynamic cache?

608


Differentiate between source qualifier and filter transformation?

994


How do you migrate data from one environment to another?

639


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1680


Enterprise data warehouse your projects phase by phase explain?

1455


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7668