Interested to Buy Any Domain ? << Click Here >> for more details...
How do you join more than 3 flat files in informatica?
- 1 Answers
- 3176 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
Reusable transformation and shortcut differences
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are active and passive transformations?
In informatica workflow manager, how many repositories can be created?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is flashback table ? Advance thanks
difference between repository database and repository service?
Mention few power centre client applications with their basic purpose?
What does refresh system mean, and what are its distinctive choice?
How to generate sequence numbers without using the sequence generator transformation?
What are the different components of powercenter?
What is standalone command task?
How many transformations can be used in mapplets.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
