without matching columns in two tables. how can you join
Answer Posted / sivaraj c
Use indirect Load through reference file which holds the file name of both source files.
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Differentiate between Load Manager and DTM?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Write the advantages of partitioning a session?
How to extract sap data using informatica?
What are the popular informatica products?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
what is unit testing?tell me proceedure
How do you load only null records into target?
Do you find any difficulty while working with flat files as source and target?
How do you handle two sessions in Informatica
How to elaborate tracing level?
What is difference between a gateway node and worker node?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
I have a flat file, want to reverse the contents of the flat file
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.