Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - Two flat files are there, each having no matching columns. How you join these two using joiner transformation?




851
views
asked marvit September 20, 2014 08:05 AM  

Two flat files are there, each having no matching columns. How you join these two using joiner transformation?


           

1 Answers



 
answered By vishnoiprem   0  
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 
This can be done by passing all ports to an expression transformation and then creating a output port say ID=1 in both the expression transformation of each file and then join it using a joiner on ID,hope this helps.
in mapping diagram area, double click on ur sequential file and rename the port as the other port in another sequential file.
it will work out. 
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert