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

how to load duplicate row in a target

4 Answers  


a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,


Different types of Power center errors?

1 Answers   Cinterco, IBM,


how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,


Explain the etl program with few examples.

0 Answers  


What is the Rankindex in Ranktransformation?

7 Answers  


when we go for unconnected lookup transformation? and why?

5 Answers   Accenture,


Which will beter perform IIf or decode?

3 Answers   TCS,


What is data merging,data cleansing,sampling?

4 Answers  


Explain the types of transformations?

0 Answers  


following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,


What is meant by query override?

0 Answers  


Categories