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


Please Help Members By Posting Answers For Below Questions

Explain about Informatica server process that how it works relates to mapping variables?

619


Do you find any difficulty while working with flat files as source and target?

670


How to extract sap data using informatica? What is abap? What are idocs?

552


Explain the shared cache and re-cache?

608


What are connected or unconnected transformations?

627






What is a transaction control transformation?

762


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1446


What is meant by incremental aggregation?

579


Explain in detail about scd type 1 through mapping.

586


Did u used latest transformations of 8.6.0? for what?

1474


How to use procedural logic inside infromatica?

632


What is difference between a gateway node and worker node?

620


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1514


What are the popular informatica products?

648


How to convert multiple rows to single row (multiple columns) in informatica

890