What is lookup table?
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 to run a sequential file stage in parallel if the stage is used on the TARGET side
How do u call shellscript/Batch file from DS?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
What are the main differences you have observed between 7.x and 8.x version of datastage?
what is the use of DSattchJob?DetachJob? where can we find it?
What is the use of datastage designer?
What are the repository tables in datastage?
how to retrive the max(sal),deptno,empno in datastage?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?
WHAT are unix quentios in datastage
What is the sortmerge collector?