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
- 9633 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 differs when we choose the sorted input for aggregator transformation?
Explain the types of transformations?
what is song in infrmatica...?
What is the use of target designer?
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.
Explain your project of banking domian.
Enlist the advantages of informatica.
What is a sequence generator transformation?
Name the different lookup cache(s)?
What is the use of an aggregator cache file?
Which development components of informatica have the highest usage?
Explain the aggregator transformation?
What is data movement mode in Informatica and difference between them?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
