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
Global and Local shortcuts. Advantages.
what is the difference between informatica6.1 and infomatica7.1
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the need for an etl tool?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Is it possible to use a client with different version than that of its Informatica server?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Differentiate between a database and data warehouse?
How do you load alternate records into different tables through mapping flow?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What you know about transaction control transformation?
What is the function of aggregator transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
How to do unit testing in informatica?