What are the diffrences between joiner transformation and
source qualifier transformation?

Answer Posted / swetha

yoU can join hetrogenious data sources in joiner
transformation which we can not achieve in source qualifier
transformation. yoU need matching keys to join two
relational sources in source qualifier transformation. Where
as you doesn't need matching keys to join two sources. Two
relational sources should come from same datasource in
source qualifier. yoU can join relatinal sources which aer
coming from different sources also.

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define sessions in informatica etl?

619


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1540


How is union transformation utilized?

571


Parameter and variable differences

1615


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

1682






What is domain and gateway node?

699


What is the format of informatica objects in a repository?

603


How can we use mapping variables in informatica? Where do we use them?

621


Explain the types of lookup transformation?

577


What do you mean by filter transformation?

557


What are the data movement modes in informatica?

703


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

718


4 yrs etl devloper roles and responsibilities?any body give solutions

1583


How to create or import flat file definition in to the warehouse designer?

618


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

9168