COOLINTERVIEW.COM DATABASE TERADATA DETAILS

Question :

Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong.

Answer :

Yes we can ..but some times we need to check the value which lookup is returning .....like it happens in teradata if we are having lookup on varchar column and record is coming from source system it never works because when informatica creates cache from there it adds space to the values.so we always have to use ltrim(rtrim)) function in lookup query. © CoolInterview.com Today's Special : Free eWeek Magazine Subscription. Absolutely Free! A D V E R T I S E M E N T

If you have the better answer, then send it to us. We will display your answer after the approval.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question

   

Category	Teradata Interview Questions
Rating	(0.0) By 0 users
Added	4/4/2008
Views	190
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: