What are the basic needs to join two sources in a source
qualifier?
Answer Posted / bidhar
Sources should be Homogeneous.Though they might not have a
joining condition.
For Example If you have Employee table and Dept Table and
the joining condition is on deptid then its not mandatory
that you must specify the joining condition.If you dont
specify the joining condition then it will have a cartesian
join.
Also the Ports Serial should be same as the SQ override
select.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is DR strategy for Informatica project?
Whats there in global repository
How do you handle two sessions in Informatica
Can we override a native sql query within informatica?
What is informatica?
Explain how many types of dimensions are available in informatica?
scenario where i can use only concurrent execution of workflow.
Explain joiner transformation in informatica
Differentiate between router and filter transformation?
What is dimensional table?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
where to store informatica rejected data? How to extract the informatica rejected data?
Explain load alternative records / rows into multiple targets - informatica
What is incremental aggregation?
What are multi-group transformations?