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
What do you understand by a term domain?
What is domain and gateway node?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is sequence generator transformation in informatica?
Differentiate between joiner and lookup transformation?
Differentiate between a repository server and a powerhouse?
What are the differences between a connected lookup and unconnected lookup?
Whats there in global repository
Global and Local shortcuts. Advantages.
What are ETL Tools?
What is the sql query overwrite in source qualifier in informatica
Which files are created during the session rums by informatics server?
What are the advantages of informatica?
What is option by which we can run all the sessions in a batch simultaneously?
how to load rows into fact table in data warehouse