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

What is Index Caches size?

855


 Informatica Checkpoints

3082


define galaxy repository in informatica

1944


What is a repository manager?

865


In which transformation you cannot drag ports into it?

1051


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5709


How we can create indexes after completing the loan process?

984


How can we store previous session logs?

787


what is size of u r database?

2045


How you prepared reports for OLAP?

1363


Explain pushdown optimization and types in informatica

860


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.

1022


How can you generate reports in informatica?

773


How identifying bottlenecks in various components of informatica and resolving them?

859


How can we remove the duplicates from flat file source?

798