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
Which are the different editions of informatica powercenter that are available?
What is a joiner transformation and why it is an active one?
Explain Dataware house architecture .how data flow from intial to end?
What is update strategy transform?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to extract the informatica rejected data?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Enlist the various types of transformations.
What are the uses of etl tools?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is meant by target load plan?
Explain joiner transformation in informatica
How do you load unique records into one target table and duplicate records into a different target table?
What are the main features of Oracle 8i with context to datawarehouse?
What is the use of an aggregator cache file?