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
How many Key we can define in remove duplicate stage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the difference types of stages?
Why do we use link partitioner and link collector in datastage?
Where do the datastage jobs get stored?
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...
What is the command line function to import and export the ds jobs?
I have a few records just I want to store data in to targets cycling way how?
Why do you need stage variables?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is difference between symmetric multiprocessing and massive parallel processing?
what are the devoleper roles in real time? plz tell i am new to datastage....
Can you explain players in datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are stage variables?