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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / veeruch


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

Why you use repository connectivity?

3 Answers   Yash Technologies,

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

How union transformation is active ?

2 Answers   Puma,

How to display First letter of Names in Caps?

7 Answers  

After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,

how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,

What are the data movement modes in informatcia?

1 Answers  

How can we use mapping variables in informatica?

0 Answers  

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

In warehouses how many schemas are there?

0 Answers  

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories