Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic needs to join two sources in a source
qualifier?
- 4 Answers
- 13093 Views
- I also Faced
- E-Mail Answers
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
How to extract sap data using informatica? What is abap? What are idocs?
How to call shell scripts from informatica?
What are the modules in Power Center
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?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is domain and gateway node?
Can we create a Integration service without a Repository service and vice versa?
How you can differentiate between connected lookup and unconnected lookup?
In which transformation you cannot drag ports into it?
Where can we find the throughput option in informatica?
Can we create two repositories on same database instance in oracle?
How can we improve session performance in aggregator transformation?
What are the types of data warehouses?
How to join three sources using joiner?
What is meant by target load plan?
