how to join the two flatfiles using the joiner t/r if there
is no matching port?

Answer Posted / vaas

Hi Jana,

How can we take a dummy column i.e what r the values would
be in that port? We need to take dummy columns on both files?

could u explain clearly. mi id is vaas31@yahoo.in

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

587


What's the layout of parameter file (what does a parameter file contain?)?

1919


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1924


What is dynamic cache?

614


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1657






Explain pushdown optimization and types in informatica

672


in reporting we add some new objects,how we get the count of the newly added objects to the report

1755


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

812


What is exclusive and normal mode for repository services?

717


Under which circumstances, informatica server creates reject files?

595


tell me about your project functionality

1870


Write the different tools in the workflow manager?

577


When do you use sql override in a lookup transformation?

591


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1483


Suppose we do not group by on any ports of the aggregator what will be the output?

582