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 Data masking in informatica..
Which is the t/r that builts only single cache memory?
How do you load only null records into target?
Differentiate between sessions and batches?
Which are the different editions of informatica powercenter that are available?
Explain the mapping variable usage example in informatica
What is a repository manager?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to differentiate between the active and passive transformations?
What is target load order?
Explain sessions. Explain how batches are used to combine executions?
Can we create two repositories on same database instance in oracle?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Repository user profiles