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

What are roles and groups and benefits of using them?

1053

in reporting we add some new objects,how we get the count of the newly added objects to the report

2187

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2128

What are the measure objects?

1196

Where can we find the throughput option in informatica?

1057

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

2102

What is union transformation?

961

Global and Local shortcuts. Advantages.

2032

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4725

How we can use union transformation?

1043

What is enterprise data warehousing?

1045

What are batches?

1091

What is the surrogate key?

1251

Enlist some properties of sessions.

1063

Whats the difference between informatica powercenter server, repositoryserver and repository?

1168