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
- 12856 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 |
Informatica settings are available in which file?
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
Where should yoU place the flat file to import the flat file defintion to the designer?
Is snow flake or star schema used? If star schema means why?
If we set dd_insert in mapping and Delete in session properties what will happen.?
How do you implement scheduling in Informatica?
What is decode in static cache?
which one is better performance wise joiner or look up
Explain factlessfact table with scenario
What is meant by incremental aggregation?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
What is the difference between a router and a filter transformation?
Teradata 
