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
What is target load order?
Is there any way to read the ms excel datas directly into informatica?
What is expression transformation?
Can we get 1st record through Informatica(without sequence number).
What is Cognos script editor?
Differentiate between a database and data warehouse?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What all are steps in up gradation of Informatica server?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How do you migrate data from one environment to another?
Is it possible to use a client with different version than that of its Informatica server?
Can informatica load heterogeneous targets from heterogeneous sources?
How to extract sap data using informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance