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 the difference between router and filter?

29


Where do we use mapping variables in informatica?

19


What is domain and gateway node?

32


What is primary and backup node?

39


What is the need for an etl tool?

16






Write the prerequisite tasks to achieve the session partition?

38


Does an informatica transformation support only aggregate expressions?

17


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1144


What is informatica powercenter repository?

14


Major difference between SQL override and Lookup Sql override

560


What are 2 modes of data movement in Informatica Server?

51


Why update strategy and union transformations are active?

11


What is meant by target load plan?

11


What is mapping debugger?

17


What is sequence generator transformation in informatica?

18