Interested to Buy Any Domain ? << Click Here >> for more details...
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
- 4 Answers
- 9462 Views
- Wipro, I also Faced
- E-Mail Answers
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
How you can differentiate between connected lookup and unconnected lookup?
What is fact table? Explain the different kinds of facts.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
what is diff b/t sorter t/r and agg have the option sorter property...
Is it possible to define a single node as a Gateway node as well as worker node?
What is primary and backup node?
Explain what is informatica metadata and where is it stored?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is a rank transform?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How can we remove the duplicates from flat file source?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How can we store previous session logs?
Explain incremental aggregation in informatica
Briefly describe lookup transformation?
