What is lookup table?
- 5 Answers
- 23777 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 |
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?
Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is Empno 1 2 3 4 5 6 7 8 9 10
What are the areas of application?
Wat is pre-load in Hashed file
What is the difference between orabulk and bcp stages?
i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
What is difference between join, merge and lookup stage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
where the log files or tables can store in DS?
my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?
how can we extract data with out having any common column
how CAN we remove duplicates in dataset?
Teradata 
