What is a range lookup?

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


Please Help Members By Posting Answers For Below Questions

How many Key we can define in remove duplicate stage?

832


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2197


What are the difference types of stages?

640


Why do we use link partitioner and link collector in datastage?

689


Where do the datastage jobs get stored?

745






Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3772


What is the command line function to import and export the ds jobs?

694


I have a few records just I want to store data in to targets cycling way how?

1909


Why do you need stage variables?

680


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2755


What is difference between symmetric multiprocessing and massive parallel processing?

666


what are the devoleper roles in real time? plz tell i am new to datastage....

1653


Can you explain players in datastage?

717


what is the custome stage in datastage? how can we impliment that one? plz tell me

1919


What are stage variables?

649