Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong.
Submitted by: AdministratorYes 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.
Submitted by: Administrator
Submitted by: Administrator
Read Online Teradata Job Interview Questions And Answers
Top Teradata Questions
| ☺ | What is stored procedure in Teradata? |
| ☺ | What is the difference between start schma and Fsldm? |
| ☺ | What are the enhanced features in Teradata V2R5 and V2R6? |
| ☺ | How teradata makes sure that there are no duplicate rows being inserted when its a SET table? |
| ☺ | What is an optimization and performance tuning and how does it really work in practical projects? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
