What are the basic needs to join two sources in a source
qualifier?
- 4 Answers
- 11508 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
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How will the document be delivered to me?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is an Integration service in Informatica?
What is data transformation manager process?
How is union transformation utilized?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How do you migrate data from one environment to another?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Which development components of informatica have the highest usage?
What is data movement mode in Informatica and difference between them?
How can you define user defied event?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How to implement security measures using repository manager?
Explain the pipeline partition with real time example?
