Answer Posted / bharathram1234
range lookup is the stage used to return a new column having the range from-to..
In that in reference u give
rng_from rng_to ret_value
1 99 A
100 199 B
.. .. ..
and master
give range as the other column
and map to range of master...
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the features of datastage flow designer?
What is quality stage?
What is the use of datastage designer?
Can you filter data in hashed file?
What is the difference between datastage and datastage tx?
Triggers,VIEW,Procedures
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How do you start developing a datastage project?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Explain the situation where you have applied SCD in your project?
Define Routines and their types?
Where the datastage stored his repository?
Name the different sorting methods in datastage.
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Which commands are used to import and export the datastage jobs?