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
What is Index Caches size?
Informatica Checkpoints
define galaxy repository in informatica
What is a repository manager?
In which transformation you cannot drag ports into it?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How we can create indexes after completing the loan process?
How can we store previous session logs?
what is size of u r database?
How you prepared reports for OLAP?
Explain pushdown optimization and types in informatica
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How can you generate reports in informatica?
How identifying bottlenecks in various components of informatica and resolving them?
How can we remove the duplicates from flat file source?