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 the difference between router and filter?
Where do we use mapping variables in informatica?
What is domain and gateway node?
What is primary and backup node?
What is the need for an etl tool?
Write the prerequisite tasks to achieve the session partition?
Does an informatica transformation support only aggregate expressions?
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.
What is informatica powercenter repository?
Major difference between SQL override and Lookup Sql override
What are 2 modes of data movement in Informatica Server?
Why update strategy and union transformations are active?
What is meant by target load plan?
What is mapping debugger?
What is sequence generator transformation in informatica?