TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?

Answer Posted / mubbasir

This can be done by passing all ports to an expression
transformation and then creating a output port say ID=1 in
both the expression transformation of each file and then
join it using a joiner on ID,hope this helps..

Is This Answer Correct ?    9 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where do we use mapping variables in informatica?

616


What do mean by local and global repository?

705


where to store informatica rejected data?

680


What are the differences between source qualifier and joiner transformation?

598


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4783






what is size of u r database?

1850


Performance tuning in UNIX for informatica mappings?

2143


What are the conditions needed to improve the performance of informatica aggregator transformation?

583


What are the restrictions of union transformation?

580


How do we call shell scripts from informatica?

599


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1897


What does role playing dimension mean?

629


What is aggregate cache in aggregator transformation?

635


what is the size of u r source(like file or table)?

1818


Differentiate between Load Manager and DTM?

1666