Interested to Buy Any Domain ? << Click Here >> for more details...
How do you join more than 3 flat files in informatica?
- 1 Answers
- 3181 Views
- ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / shashikiran
If it is horizontal join then we should use joiner transformation having common columns in both the flat files if it is more than 3 flat files, then number of joiners will no. of flat files - 1 i.e,
if suppose there are 4 flat files then 3 joiners are used.
If the flat files structure is same then we can go for vertical joining by using Union transformation or by using indirect file loading concept.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the advantage of informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
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
What is the meaning of up gradation of repository?
Performance tuning in UNIX for informatica mappings?
What are junk dimensions?
How to update source definition?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is the cumulative sum and moving sum?
What is the need for an etl tool?
What is resilience time?
How many number of sessions can one group in batches?
Can we get 1st record through Informatica(without sequence number).
What is the function of aggregator transformation?
Explain about Informatica server process that how it works relates to mapping variables?
