Interested to Buy Any Domain ? << Click Here >> for more details...
How do you join more than 3 flat files in informatica?
- 1 Answers
- 3166 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 |
What are the rank caches?
star and snowflake schema?
What is galaxy shema
what is data driven?
How you prepared reports for OLAP?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
What are the designer tools for creating transformations?
How do you do error handling in Informatica?
how do u move the code from development to production?
how can u load the data in time dimension?
What is a command that used to run a batch?
what is DSS?
Teradata 
