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
- 13028 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 |
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
What is the benefit of session partitioning?
How can we remove the duplicates from flat file source?
have you developed documents in your project? and what documents we develop in realtime?
Why we need XMLs?
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario
Different circumstance which drives informatica server to expel records?
Explain your project of banking domian.
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
What is galaxy shema
Teradata 
