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
sd-->sq-->exp>
...>join-->tgt
sd1-->sq1-->exp1>

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by target load plan?

88


What are connected or unconnected transformations?

130


Explain what is informatica metadata and where is it stored?

91


How to handle decimal places while importing a flatfile into informatica?

114


What is data movement mode in Informatica and difference between them?

130






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.

108


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?

103


What is the difference between Active and Passive transformation?

108


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

81


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 ?

1172


How does a rank transform differ from aggregator transform functions max and min?

93


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1105


How to load a Dimension ? and how to load a fact table?

427


Can you generate sequence numbers without using the sequence generator transformation?

81


How might one distinguish in the case of mapping is right or not without associating session?

90