By using joiner t/r we can join only 2 tables, SO if want
join more than 2 flat files ,How can i join?



By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i jo..

Answer / rahul

for n source we required n-1 joiner t/r.

ex: if we have 3 flat file dan we requried 2 joiner t/r

Is This Answer Correct ?    16 Yes 0 No

Post New Answer

More Informatica Interview Questions

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,


What are the data movement modes in informatcia?

3 Answers  


How do you use reject loader.

0 Answers  


what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,






My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,


can we override a native sql query within informatica? Where do we do it?

0 Answers  


Define informatica repository?

2 Answers   Wipro,


when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,


How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,


what are cost based and rule based approaches and what is the difference?

1 Answers  


what is incremental aggregation ,with example?

2 Answers  


Categories