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


Please Help Members By Posting Answers For Below Questions

Which are the different editions of informatica powercenter that are available?

803


What is a joiner transformation and why it is an active one?

783


Explain Dataware house architecture .how data flow from intial to end?

2340


What is update strategy transform?

811


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2047


How to extract the informatica rejected data?

999


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.

1382


Enlist the various types of transformations.

744


What are the uses of etl tools?

873


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?

2012


What is meant by target load plan?

746


Explain joiner transformation in informatica

895


How do you load unique records into one target table and duplicate records into a different target table?

965


What are the main features of Oracle 8i with context to datawarehouse?

1876


What is the use of an aggregator cache file?

919