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
- 13069 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 |
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
How do you set a varible in incremental aggregation
How to display null values on a target & non-null values on a target?
Difference between Data and Index Caches?
What is the difference between procedure and stored procedur?
Define pmcmd command?
why we use informatica in our project?
how to load dimension table and fact table. plz tell me the steps.
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Can we insert ,update ,delete in target tables with one update strategy tran.?
What are the different options available for update strategy?
Teradata 
