What is a range lookup?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guest
With range lookup , lookup can be performed such that column
from reference field lies within a set values(columns) in
the stream link rather than just joining on a exact match
Is This Answer Correct ? | 2 Yes | 3 No |
What is the process of killing a job in datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Differentiate between validated and Compiled in the Datastage?
Hi Vijay here For Four CPU's how many nodes will required?
What is a quality stage in datastage tool?
What are stage variables, derivations and constants?
What is process model?
what is the main differences between Lookup, Join and Merge stages?
Which warehouse using in your datawarehouse
where we use config file as parameter ?
What is the difference between datastage and datastage tx?
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?