how to join two flat file if they have diff. structure?how to join one relational and one flat file?
Answer Posted / pradosh
if the flat files has diff stracture then
that means take flat file source then take 2 exp transformation in which u take variabl ports i.e a=1 and exp1 is b=1 then based on condition u take a joined trans and connect to target.
join takes diferent sources
|Is This Answer Correct ?||4 Yes||0 No|
What is meant by target load plan?
What are connected or unconnected transformations?
Explain what is informatica metadata and where is it stored?
How to handle decimal places while importing a flatfile into informatica?
What is data movement mode in Informatica and difference between them?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is the difference between Active and Passive transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How does a rank transform differ from aggregator transform functions max and min?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to load a Dimension ? and how to load a fact table?
Can you generate sequence numbers without using the sequence generator transformation?
How might one distinguish in the case of mapping is right or not without associating session?