TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?
Answer Posted / mubbasir
This can be done by passing all ports to an expression
transformation and then creating a output port say ID=1 in
both the expression transformation of each file and then
join it using a joiner on ID,hope this helps..
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
What is meant by lookup transformation? Explain the types of lookup transformation?
What is a router transformation?
Enlist the tasks for which source qualifier transformation is used.
can u any challenge your project?
What is joiner transformation?
What is the procedure for creating independent data marts from informatica 7.1?
Can you generate sequence numbers without using the sequence generator transformation?
How to Create a folder using pmrep command?
What if the source is a flat-file?
What is the difference between informatics 7x and 8x and what is latest version?
What are connected or unconnected transformations?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
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
What does cheating measurement mean?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?