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

Difference between sequential file and data set?

1 Answers  

---

Where do the datastage jobs get stored?

1 Answers  

---

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 Answers  

---

Can you explain tagbatch restructure operator?

1 Answers  

---

What are the different layers in the information server architecture?

1 Answers  

---

Enlist various types of routines in datastage.

1 Answers  

---

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers   IBM,

---

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

8 Answers   Semantic Space,

---

what is use of SDR function?

1 Answers   CGI,

---

What is RCP?

2 Answers   TCS,

---

How to add zero "0" before record in a field?

4 Answers  

---

what about data stage requirement

1 Answers  

---