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

Answer Posted / pushparao

if there is no matching column two flat files, that means
two tables are different,no need to join the source
definitions in the designer.
there is possibility to join them.
create common columns in both expression transformations.
seqgen
|
sd-->sq-->expr
Joiner-->td
sd-->sq-->expr
|
seqgen

Is This Answer Correct ?    10 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6093


Briefly describe lookup transformation?

601


What is mapping debugger?

574


Explain why we use partitioning the session in informatica?

617


Can you use flat files in Mapplets.

2226






update strategy transformation in informatica

643


Describe the impact of several join conditions and join order in a joiner transformation?

649


What is the Process to creating lookup transformation in informatica

587


What is meant by lookup transformation? Explain the types of lookup transformation?

571


what is unit testing?tell me proceedure

1783


What is the commit type if you have a transaction control transformation in the mapping?

654


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1558


What is the benefit of session partitioning?

598


What are the modules in Power Center

1240


What is decode in informatica?

658