What are the basic needs to join two sources in a source
qualifier?
Answer Posted / 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 |
Post New Answer View All Answers
What is expression transformation?
Parameter and variable differences
can anyone suggest best free Talend data integration training online
What is a grid in Informatica?
What are the types of caches in lookup? Explain them.
Why update strategy and union transformations are active? Explain with examples.
what is mean by complex business rule ?
Explain the use of aggregator cache file?
can you please explain me pre session and post session options?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How can we remove the duplicates from flat file source?
What is a router transformation?
can u any challenge your project?
Describe data concatenation?
Explain the different dimensions.