GeekInterview.com
Series: Subject: Topic:
Question: 665 of 725

What r the basic needs to join two sources in a source qualifier?

Two sources should have primary and Foreign key relation ships.
Two sources should have matching data types.

Asked by: Interview Candidate | Asked on: Sep 21st, 2004
Showing Answers 1 - 3 of 3 Answers
rishi

Answered On : Dec 14th, 2005

The both the table should have a common feild with same datatype.

Its not neccessary both should follow primary and foreign relationship. If any relation ship exists that will help u in performance point of view.

  
Login to rate this answer.
Surendra

Answered On : Apr 9th, 2006

Also of you are using a lookup in your mapping and the lookup table is small then try to join that looup in Source Qualifier to improve perf.

Regards

SK

  
Login to rate this answer.
Yuvaraj

Answered On : Jan 10th, 2007

Both the sources must be from same database.

  
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 Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Abinitio

Analysis services

Basics

BO Designer

Business Intelligence

Business Objects

Cognos

Concepts

Data Integration

DataStage

ETL

Hyperion

Impromptu

Informatica

MicroStrategy

Reportnet

Interview Coaching

How do you deal and overcome major challenges?

Has there been a time when you were presented a problem and solved it?

Do you seek advice from others when you have a question?

What are the career opportunities available for MCA Graduates?

What are the career options available in Software Testing Industry?

What will you do when you are not able to get your message across to your audience?

What do you think about continuous learning?

Career Options for BCA Graduates

How productive are you?

Describe a time when you had to listen to someone.

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.

Subscribe