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

Define data aggregation?

0 Answers  

---

I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers   CGI,

---

A flatfile 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 the job?pls give the steps?

3 Answers   TCS,

---

what is ds administrator used for?

0 Answers  

---

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers  

---

What are sequencers?

0 Answers  

---

To see hidden files in LINIX?

0 Answers   CTS,

---

what is the difference between datasatge and datastage TX?

6 Answers  

---

how to sort two columns in single job in datastage.

0 Answers   TCS,

---

specify data stage strength?

1 Answers  

---

in aggregator , how can i get the sum in readable format

4 Answers   IBM,

---

how to identifie,is it innerjoin,leftouter join in lookup?

2 Answers   Hexaware,

---