I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
- 6 Answers
- 13603 Views
- Cap Gemini, CTS, I also Faced
- E-Mail Answers
Answer Posted / ravikumar2614
Data flow like:
SRC-->SQ-->SEQ_GEN-->EXP-->AGGR-->FLTR-->TGT
create new port as M_PORT in Exp and leave empty.
write a logic in AGGR for M_PORT as MAX(SEQ_PORT)
Write a logic in FLTR as "SEQ_PORT!=1 AND M_PORT-SEQ_PORT!=0"
If my approach is wrong correct me on ravi.infop@gmail.com
| Is This Answer Correct ? | 14 Yes | 5 No |
Post New Answer View All Answers
What are the performance considerations when working with aggregator transformation?
What is meant by pre and post session shell command?
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
How to partition the Session?
Briefly explain the aggregator transformation?
What you know about transaction control transformation?
Different sorts of metadata that stores in the storage facility?
What do mean by local and global repository?
What are the features of complex mapping?
Differentiate between a database and data warehouse?
What is a repository manager?
Describe the impact of several join conditions and join order in a joiner transformation?
wf dont have integration severances how you can run?
What is difference between a gateway node and worker node?
What is the use of code page?
