sangeetha

• Sep 25th, 2005

 

It is a transformation which represents the data Informatica server reads from source.

sithusithu

 Profile Answers by sithusithu 

• Jan 19th, 2006

 

When you add a relational or a flat file source definition to a mapping, you need to connect it to a Source Qualifier transformation. The Source Qualifier represents the rows that the Informatica Server reads when it executes a session.

Cheers,

Sithu

Kamal

• Sep 7th, 2007

 

Source Qualifier is an default transformation in informatica. It fires a SQL query against your source database.   Even we can View the query in Properties tab.

pushparao

• Sep 16th, 2007

 

Source qualifier transformation, not only extracts the  data from the source definition, but also combines the two or more souce defintions (same database), apply the user defined joiner condition for reject the unwanted data as early as possible.

rameshbingi

 Profile Answers by rameshbingi 

• Nov 15th, 2007

 

HiIt is process of changing the default sql return by source qualifier using sorted input, user defined joins, filter and select distinctBingi Ramesh

Sant_parkash

 Profile Answers by Sant_parkash Questions by Sant_parkash

• Jan 30th, 2008

 

This is the base transformation. You cannot opertae directly on Source, so Informatica provide this transformation and the basic ETL(Extraction Transformation Loading) logic starts from Source Qualifier.

umasankargi

 Profile Answers by umasankargi 

• May 28th, 2008

 

The source qualifier transformation is used manily for informatica readible format only

Rashmirekha

 Profile Answers by Rashmirekha 

• Jul 10th, 2008

 

Source qualifier is the recordeset (select statement ) for the source data.Source definition is the structure of the source but the  data is kept on source qualifier as a buffer.
cheers,
Rashmi
9916631010

savitha1

 Profile Answers by savitha1 

• Jul 14th, 2008

 

source qualifier is used to convert the source data type to Informatica readable format.

we can do mapping without source qualifier..in that case the datatypes of the source columns should be same as what will be mentioned in source qualifier..

sprajarajan

 Profile Answers by sprajarajan Questions by sprajarajan

• Aug 8th, 2008

 

Source Qualifier Is the default Transformation.
Through The source Qualifier Transformation Informatica Reads The Data.
We can Filter The Data.
We can sort the Data.
Its also Used to Join Homogeneous Source systems.
We can Join Any number of Sources in Singlae Source Qualifier.
We Can't Join the Flatfiles In sourcequalifier Because Flatfiles Are Heterogeneous When we open the Flatfiles At sourcequalifier At the time All The options are Disabled.

ORAINFO

 Profile Answers by ORAINFO 

• Nov 19th, 2008

 

The SOURCE QUALIFIER transformation tells the integration service what all data to read from the from the source and more importantly to convert the datatypes of the source to the one that is understood by the Informatica tool.Correct me if I am wrong.

job_infa

 Profile Answers by job_infa 

• Jan 28th, 2009

 

The Source Qualifier transformation represents the rows that the Integration Service reads when it runs a session.
Use the Source Qualifier transformation to complete the following tasks:
-Join data originating from the same source database.
-Filter rows when the Integration Service reads source data.
-Specify an outer join rather than the default inner join.
-Specify sorted ports.
-Select only distinct values from the source.
-Create a custom query to issue a special SELECT statement for the Integration Service to read source data.

ASHOK1324

 Profile Answers by ASHOK1324 

• Apr 21st, 2009

 

It is a transformation which is automatically generated to read the data from source tables into informatica designer.

venkat224

 Profile Answers by venkat224 

• Dec 24th, 2009

 

Source Qualifier is one of the transformations, which converts any type of data to the relational format. So that, can easily be used for any of the operations on the data.

joyfun23

 Profile Answers by joyfun23 

• Jan 26th, 2010

 

1. Source Qualifier is the most important transformation which convert the source data type in to compatible NATIVE datatype of a mapping.

2. Without a SQ a mapping can not be created, after extraction of a record various transformation can be performed only with native datatypes for e.g. in a relational source table a Varchar2 datatype will be used as 'String' Native data in mapping and we can not take String as datatype in source definition.