What are the basic needs to join two sources in a source
qualifier?
- 4 Answers
- 11467 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ricky
Both the sources should come from homogenious / same
database.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / swetha
Two sources should have primary and Foreign key relation ships.
Two sources should have matching data types.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / madhu
The Transformation which Converts the source(relational or
flat) datatype to Informatica datatype.
So it works as an intemediator between and source and
informatica server.
Tasks performed by qualifier transformation:-
1. Join data originating from the same source database.
2. Filter records when the Informatica Server reads source
data.
3. Specify an outer join rather than the default inner join.
4. Specify sorted ports.
5. Select only distinct values from the source.
6. Create a custom query to issue a special SELECT
statement for the Informatica Server to read source data.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the difference between view and materialised view?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
What are the active and passive transforamtions?
Hi experts, can anyone tell how much we use plsql in real time
what is degenerated dimension?
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
How to extract sap data using informatica? What is abap? What are idocs?
What are the different components of powercenter?
How will you update the first four rows and insert next four rows in a mapping?
How i can upload the MainFrame source For Informatica ?
Teradata 
