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...

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

how can u handle null values in transformer stage.

7 Answers  

---

I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,

---

1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

2 Answers   Mind Tree,

---

how to closeing records after 10,000 records come?

3 Answers  

---

What is the difference between Link collector and Funnel Stages?

1 Answers  

---

What is container and then types?

1 Answers  

---

With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,

---

explain about citrix scheduling tool in datastage

0 Answers   HSBC,

---

how can find maximum salary by using Remove duplicate stage?

5 Answers   IBM,

---

If you want to use a same piece of code in different jobs, how will you achieve this?

0 Answers  

---

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

---

how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers   Wipro,

---