Interested to Buy Any Domain ? << Click Here >> for more details...
What is lookup table?
- 5 Answers
- 25436 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 difference between symmetric multiprocessing and massive parallel processing?
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
what is the diff b/w switch and filter stage in datastage
6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
what is materialized view used datastage?
project Steps,hits, Project level HArd things,Solved methods?
What is mapping?
i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
what is usage of datastage with materialized views
What are constraints and derivations?
Teradata 
