Interested to Buy Any Domain ? << Click Here >> for more details...
What is lookup table?
- 5 Answers
- 25578 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 PX?
what is initial load and incremental load
How can we do null handling in sequential files
explain unit testing,systemtesting,integrated testing
How do you import and export the datastage jobs?
what is advantages of snowflake when it is used?
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3
How many Nodes configuration file you used in your last project?
What is a quality stage?
I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know
i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?
Teradata 
