What is lookup table?
- 5 Answers
- 24196 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / badhrinath r
look up stage performs the same action as merge and join
stages do. But here we have a table as lookup table which
will be having a key column with the source table. if the
key colums in source are matched with the lookup table, that
rows will only be passed to output. Others can be taken in
reject.
| Is This Answer Correct ? | 26 Yes | 5 No |
Answer / maruthi
LOOK UP TABLE IS A REFERENCE TABLE IN WHICH WE WILL PASS A
KEY COLUMN FROM SOURCE TABLE AND WE WILL GET THE REQUIRED
DATA ONCE THE KEY COLUMN MATCHES.
| Is This Answer Correct ? | 23 Yes | 3 No |
Answer / geed
The lookup table is a table it will reflect the changes in
the target by the source
| Is This Answer Correct ? | 15 Yes | 8 No |
Answer / yarramasu
look up table is key based and it is used for combian the
data and its saved in physical memory (RAM)
| Is This Answer Correct ? | 4 Yes | 7 No |
Answer / hari
Apart from the DataStage view Look Up table is a Dimension
table it contains the descriptive information about the
business.
| Is This Answer Correct ? | 1 Yes | 11 No |
What is the difference between Link collector and Funnel Stages?
What is diff between Junk dimensions and conform dimension?
What is the difference between in process and inter process?
how to do pergformence tuning in datastage?
why we use hash file for lookup?
What is APT_DUMP_SCORE?
source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235
What are the enhancements made in datastage 7.5 compare with 7.0?
How we can covert server job to a parallel job?
What is the use of hoursfromtime() function in transformer stage in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How to implement complex jobs in data stage?
Teradata 
