Interested to Buy Any Domain ? << Click Here >> for more details...
How do you join more than 3 flat files in informatica?
- 1 Answers
- 3191 Views
- ITC Infotech, I also Faced
- E-Mail Answers
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 |
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
Explain what transformation and how many are there in informatica?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
HOW TO GET THE LATEST DATA IN SCD ?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
How to list Top 10 salary, without using Rank Transmission?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
Explain the code page compatibility?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
Teradata 
