how to join the two flatfiles using the joiner t/r if there
is no matching port?
Answer Posted / vin
create dummy1 port in flat file1
create dummy2 port in flat file2
assign the value '1' to both dummy1 and dummy2.
In the lookup condition use dummy1=dummy2. This is going to be always true so all the records are took into consideration.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Please let me know how to make encryption and decryption with example?
How can we create index after completion of load process?
What is the reusable transformation?
Define Pmrep command?
How many types of sessions are there in informatica.please explain them?
Differentiate between Load Manager and DTM?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
can anyone explain me about retail domain project in informatica?
Mention a few design and development best practices for informatica?
What is data transformation manager process?
What is a passive transformation?
How are the sources and targets definitions imported in informatica designer?
Explain sessions?
What is depict expression change?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?