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
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explian the Process of deployment groups in informatica
What is a code page?
Explain the use of aggregator cache file?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the informatica performance improvement tips
How many ways are there to do 'remove duplicate records in informatica'?
How you prepared reports for OLAP?
Differentiate between a database and data warehouse?
what is song in infrmatica...?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are roles and groups and benefits of using them?
What are the different versions of informatica?