What is a range lookup?

Question Posted / guest

2 Answers
7772 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is a range lookup?..

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

What is a range lookup?..

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

Post New Answer

More Data Stage Interview Questions

How to lode data in sequntional files perform faster?

1 Answers Polaris,

A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?

1 Answers TCS,

What are the different common services in datastage?

0 Answers

What are datastage sequences?

0 Answers

how can i abort the job if i get more than 100 errors in job log?

6 Answers Accenture,

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers IBM,

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers TCS,

How can we select pr retrieve the particular row in dataset by using orchadmin command?