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
On which transformations you created partitions in your project?
Differentiate between router and filter transformation?
What is exclusive and normal mode for repository services?
How to generate sequence numbers without using the sequence generator transformation?
Where is metadata stored?
Explain the code page compatibility?
What is joiner transformation in informatica?
How we can create indexes after completing the load process?
How can we handle two sessions in informatica?
What is the need of an ETL tool?
Explain the tuning lookup transformation - informatica
What is a connected transformation?
Why sorter is an active transformation?
What is a dimensional model?
What are the components of workflow manager?