Interested to Buy Any Domain ? << Click Here >> for more details...
How do you join more than 3 flat files in informatica?
- 1 Answers
- 3094 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 active transformations? Name them.
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
how many ways can we implement SCD2?
without using rank transformation how can we rank items by using some other transformations
What are the different versions of informatica?
why we use informatica in our project?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
Limitation of REPLACESTR. Is there any character limitation to it.
what is mean by flag 4 in update strategy t/r
What is a router transformation?
How to recover sessions in concurrent batches?
what is dimension table?
Teradata 
