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 features of datastage flow designer?

1099

---

What is quality stage?

1042

---

What is the use of datastage designer?

1218

---

Can you filter data in hashed file?

3824

---

What is the difference between datastage and datastage tx?

1114

---

Triggers,VIEW,Procedures

1262

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3290

---

How do you start developing a datastage project?

1160

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2247

---

Explain the situation where you have applied SCD in your project?

2086

---

Define Routines and their types?

1257

---

Where the datastage stored his repository?

1137

---

Name the different sorting methods in datastage.

1098

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

964

---

Which commands are used to import and export the datastage jobs?

1460

---