Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How do you join more than 3 flat files in informatica?



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

Post New Answer

More Informatica Interview Questions

What are active transformations? Name them.

1 Answers  


A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,


how many ways can we implement SCD2?

4 Answers   IBM, TCS,


without using rank transformation how can we rank items by using some other transformations

2 Answers  


What are the different versions of informatica?

0 Answers  


why we use informatica in our project?

2 Answers   TCS,


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.

3 Answers   Amdocs, Deloitte,


Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,


what is mean by flag 4 in update strategy t/r

6 Answers  


What is a router transformation?

0 Answers  


How to recover sessions in concurrent batches?

3 Answers  


what is dimension table?

17 Answers  


Categories