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
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 ?
Briefly describe lookup transformation?
What is mapping debugger?
Explain why we use partitioning the session in informatica?
Can you use flat files in Mapplets.
update strategy transformation in informatica
Describe the impact of several join conditions and join order in a joiner transformation?
What is the Process to creating lookup transformation in informatica
What is meant by lookup transformation? Explain the types of lookup transformation?
what is unit testing?tell me proceedure
What is the commit type if you have a transaction control transformation in the mapping?
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
What is the benefit of session partitioning?
What are the modules in Power Center
What is decode in informatica?