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

What are the job parameters?

0 Answers  

---

What are the steps required to kill the job in Datastage?

0 Answers  

---

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

2 Answers  

---

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 Cleanup Resources and when do you use it?

2 Answers  

---

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 Answers  

---

DataStage Scenario based Interview Questions

1 Answers  

---

I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,

---

Triggers,VIEW,Procedures

0 Answers   CTS,

---

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

3 Answers   HCL,

---

diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,

---

what is mapping lookup

1 Answers  

---