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
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How to generate sequence numbers using expression transformation?
Define enterprise data warehousing?
What is a repository? And how to add it in an informatica client?
What is fact table? Explain the different kinds of facts.
What is dimensional table? Explain the different dimensions.
Explain why we use partitioning the session in informatica?
how to create user defined function (udf) in informatica
What is deployment group?
What is informatica etl tool?
tell me 5 session failure in real time how can you solve that in your project?
What is dynamic cache?
What are the new features of informatica 9.x developer?
What is the difference between a repository server and a powerhouse?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?