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
When do you use sql override in a lookup transformation?
r u done any partitions in ur project?
What are the components of the workflow manager?
What is a passive transformation?
What is workflow? What are the components of workflow manager?
How we can create indexes after completing the load process?
How to elaborate tracing level?
Can you use flat files in Mapplets.
Reusable transformation and shortcut differences
What is workflow manager?
Where can we find the throughput option in informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How do you load first and last records into target table?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Sequence generator, when you move from develoment to production how will you reset