How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
Answer Posted / mallikarjun
Hi Ajith,
It is Possible to Join data from a flat file and a relation
source, this can be done with the help of a joiner
transformation where you have to map one input port to the
relation data column and other to the flat file coumn and
give the joiner condition.. Hope this will help you or drop
a mail...
Thanks & Regards,
Mallikarjun
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
Explain informatica architecture - version 8 / 9
What are the mapping parameters and mapping variables?
What is lookup change?
Where are the source flat files kept before running the session?
Differences between connected and unconnected lookup?
Suppose we do not group by on any ports of the aggregator what will be the output?
What you know about transaction control transformation?
Can we get 1st record through Informatica(without sequence number).
What is InformaticaPowerCenter?
Define enterprise data warehousing?
Different sorts of metadata that stores in the storage facility?
Which transformation is needed while using the Cobol sources as source definitions?
explain about unit testing? in real time?
Explain the etl program with few examples.
Sequence generator, when you move from develoment to production how will you reset