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 ? | 34 Yes | 9 No |
Post New Answer View All Answers
What is rank transform?
What is event and what are the tasks related to it?
What are the tasks that can be performed using sq?
In warehouses how many schemas are there?
how to load rows into fact table in data warehouse
Explain the mapping variable usage example in informatica
Where are the source flat files kept before running the session?
How to differentiate between the active and passive transformations?
What is sorter transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
How do you promote a non-reusable transformation to reusable transformation?
what is informatica metadata?
How many input parameters can exist in an unconnected lookup?
What is a snowflake schema?
what are 3 tech challenges/ common issues you face?