I HAVE A SOURCE FILE CONTAINING
1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B
AND IN TARGET I SHOULD GET LIKE
1|A+B+C+D
2|A+B
3|A+B
WHICH TRANSFORMATION I SHOULD USE
Answer Posted / amedela chandra sekhar
By using aggregator t/r we can achieve.
use || function
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are active transformations.
How to load data in informatica ?
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
where to store informatica rejected data? How to extract the informatica rejected data?
How to go to the older version for a mapping?
Please let me know how to make encryption and decryption with example?
explain one complex mapping with logic? sales project?
Mention few advantages of router transformation over filter transformation.
What is informatica powercenter repository?
Can we create a Integration service without a Repository service and vice versa?
How to elaborate powercenter integration service?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
what are the deliverables?in your project?
How can we handle two sessions in informatica?