How do you join more than 3 flat files in informatica?
Answer / 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 |
What are the different clients of powercenter?
how to declare array in plsql?
What is depict expression change?
In operator is used in which transformation in informatica 8.6.0
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
How do you change a non-reusable transformation to reusable transformation?
How can we integrate different flat file data in a single mapping and with in a single execution
How informatica recognizes mapping?
what is the -ve test case in your project.
What are the uses of etl tools?