Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

why we use source qualifier transformation?

Question Posted / vidya acharya

Answer Posted / vidya acharya

1. SOURCE QUALIFIER TRANSFORMATION represents the rows that informatica powercenter server reads from RELATIONAL or FLAT FILE SOURCE when it runs the session. 

2. When relational or flat file source definition is added to the mapping, informatica server creates the SQ by default. thus, its a default transformation in informatica.

3. Any source(relational/flat file) cannot be read without using SQ as it converts the database specific datatype to informatica native datatype.

4. For relational sources, additional properties can be      configured:
     - join 2 or more table originating from same source
     - source filter.
     - number of sorted ports
     - select distinct rows
     - user defined join
     - specify pre-sql and post-sql query
     - sql override.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you change a non-reusable transformation to reusable transformation?

1046

What are the uses of etl tools?

1175

Explain the aggregator transformation?

1221

What are the steps involved in the migration from older version to newer version of Informatica Server?

2153

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1228

Define sessions in informatica etl?

1101

Is stop and abort are same in informatica?

1048

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

2028

How to load a Dimension ? and how to load a fact table?

1461

How you know when to use a static cache and dynamic cache in lookup transformation?

1916

Differences between connected and unconnected lookup?

1271

can u any challenge your project?

2083

permutations of mapplet

2548

How to open an older version of an object in the workspace?

1264

What is informatica metadata and where is it stored?

1042