Interested to Buy Any Domain ? << Click Here >> for more details...
How do you join more than 3 flat files in informatica?
- 1 Answers
- 3243 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
Explain the types of transformations?
What is a rank transform?
How to implement security measures using repository manager?
Suppose we do not group by on any ports of the aggregator what will be the output?
How do you change a non-reusable transformation to reusable transformation?
what is size of u r database?
What are active transformations.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How can you generate reports in informatica?
Design time, run time. If you don't create parameter what will happen
How do you use reject loader.
Explain the pipeline partition with real time example?
Explain the types of lookup transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is meant by active and passive transformation?
