TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?
Answer Posted / prasadreddy
by using the dummy ports u can do..but the both the data
types should be same
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain pushdown optimization $pushdownconfig parameter - informatica
How to handle decimal places while importing a flatfile into informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How many ways are there to do 'remove duplicate records in informatica'?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain why we use partitioning the session in informatica?
How to improve the performance of a session using sorter transformation?
During the running session, output files are created by informatica server. Enlist few of them.
How to Create a folder using pmrep command?
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 ?
can you please explain me pre session and post session options?
What can we do to improve the performance of informatica aggregator transformation?
Briefly define reusable transformation?