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
Explain sessions. Explain how batches are used to combine executions?
On which transformations you created partitions in your project?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Why do we need informatica?
Slowly changing dimensions, types and where will you use them
Describe an informatica powercenter?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Design time, run time. If you don't create parameter what will happen
What differs when we choose the sorted input for aggregator transformation?
How to configure mapping in informatica?
How would you join a node to the already existing domain?
How many dimensions are there in informatica?
what is the size of u r source(like file or table)?
How do you load alternate records into different tables through mapping flow?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?