GeekInterview.com
Series: Subject: Topic:
Question: 162 of 726

What is the difference between source definition database and source qualifier?

Asked by: Interview Candidate | Asked on: Sep 11th, 2007
Showing Answers 1 - 2 of 2 Answers
vemurisasidhar

Answered On : Sep 24th, 2007

View all answers by vemurisasidhar

a source definition database contain the datatypes that are used in the orginal database from which the source is extracted. where the source qualifier is used to convert the source definition datatypes to the informatica datatypes. which is easy to work with.

Yes  2 Users have rated as useful.
  
Login to rate this answer.
madhu.tella

Answered On : Mar 25th, 2010

View all answers by madhu.tella

Source definition in database is simply the table definition, but the source qulifier is one of the transformation in informaitca from which we can specify the data selection criteria to the database.

For example if you are using only 3 columns out of the available 10 columns in a table along with some filter conditons to load data in the target table. We can simply select those 3 coulmns and include the filter conditions either in the query or in the filter condition in the source qualifier properties.

Yes  1 User has rated as useful.
  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.