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 are the different types of transformation available in informatica.
What are the tuning techniques you applied during your last project
How to convert multiple rows to single row (multiple columns) in informatica
How to load data in informatica ?
What is the difference between STOP and ABORT options in Workflow Monitor?
What do you understand by SOA of Informatica?
What is mapping debugger?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What does refresh system mean, and what are its distinctive choice?
What is a dimensional model?
What is the procedure for creating independent data marts from informatica 7.1?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is joiner change?
Can anyone tell me the new features in Informatica 9 Version?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs