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 create a Integration service without a Repository service and vice versa?
What is incremental aggregation?
can u give example for factless fact table
Is it possible to revert a global repository to local one and why?
How can we improve session performance in aggregator transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
How many numbers of sessions can one group in batches?
How is union transformation utilized?
What is a pre-defined event and user-defined event?
Enterprise data warehouse your projects phase by phase explain?
Under which circumstances, informatica server creates reject files?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How to update or delete the rows in a target, which do not have key fields?
On which transformations you created partitions in your project?