NEW INTERVIEW QUESTIONS.COM DATA WAREHOUSING INTERVIEW QUESTIONS INFORMATICA INTERVIEW QUESTIONS DETAILS

Add to My Questions | Forward | Print

Question

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can u map these three ports directly to target?

Answer

if u drag three hetrogenous sources and populated to target without any join means you are entertaining Carteisn product. If you don't use join means not only diffrent sources but homegeous sources are show same error. If you are not interested to use joins at source qualifier level u can add some joins sepratly. I think in the Source Qualifier if we want to join more than 1 source, then it is possible only if the sources are coming from a single SCHEMA. So the answer for the above question is 'NO'. Answered By: CHAKRADHAR    Date: 5/24/2007 we cant drag and drop the ports from different sources to a single source qualifier, use seperate sq for defferent sources and join then by using joiner. Answered By: chandu    Date: 12/27/2007 As, in this case you will use 2 joiners 1st joiner you take SQ of Oracle and SQL, then you add another joiner and add Informix SQ to it. then to single target map it as we know. Source qualifier ? Homogeneous source Joiner ? Heterogeneous source Answered By: priya    Date: 2/6/2008 © NewInterviewQuestions.com

Answer:*
Name:*
Email Address:*
Verification Code	Not readable? Load New Code
Enter the above shown code:*

Category	Informatica Interview Questions
Rating	(0.0) By 0 users
Added	7/26/2006
Views	153814
Rate it!	* * * * * * * * * * * * * * *
Free Offers:	300 Free Magazines for you. No credit card required. No Shipping Charges. Absolutely Free for 1 Year.

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email: