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 some examples of informatica etl programs?

980

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

1458

What is a joiner transformation and why it is an active one?

1159

Explain sql transformation in script mode examples in informatica

1204

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7490

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10725

Explain target update override in informatica

1183

What is a predefined event?

1134

What is the session task and command task?

1109

What is the difference between Active and Passive transformation?

1213

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1687

What is the commit type if you have a transaction control transformation in the mapping?

1094

Name the different lookup cache(s)?

1288

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2397

Explain lookup transformation is active in informatica

1144