Answer Posted / 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...

What are the types of containers in datastage?

1143

---

What is a quality stage in datastage tool?

1023

---

How do you run datastage job from the command line?

1027

---

how can we create rank using datastage?what is the meaning of rank?

8705

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2196

---

What is the use of datastage director?

972

---

Can you filter data in hashed file?

3721

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

1022

---

Differentiate between operational datastage (ods) and data warehouse?

1116

---

How many types of stage?

1131

---

Define oconv () and iconv () functions in datastage?

1340

---

How you can fix the truncated data error in datastage?

1674

---

How do u convert the columns to rows in datastage?

1139

---

What are the processing stages?

1039

---

Explain the importance of surrogate key in data warehousing?

1128

---