how to get max value record into one target and remaining
records into another target?
Answer Posted / swarup
sorter(key=requiredkey)
expression
router=1stgrp(o_cnt=1),2nd grp(o_cnt>=1)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
wat are deployement groups in informatica, how it will be used for developers
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
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is informatica powercenter repository?
What is a transaction control transformation?
What are the restrictions of union transformation?
What the difference is between a database, a data warehouse and a data mart?
Separate from an archive server and a powerhouse?
How to do unit testing in informatica? How to load data in informatica ?
How to Create a folder using pmrep command?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is parallel processing in informatica?
How do you change a non-reusable transformation to reusable transformation?
What is Index Caches size?
in reporting we add some new objects,how we get the count of the newly added objects to the report