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

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

---

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

---

How do you get log info into a file?

1 Answers  

---

what is the definitions for Datawarehose and Datamart?

4 Answers  

---

What are constraints and derivations?

0 Answers  

---

What is the default execution order of the sequential file?

3 Answers  

---

how can we create tables in datastage?

1 Answers  

---

What are the areas of application?

0 Answers  

---

Difference in the implementation of lookup and join stages,in joining two tables?

7 Answers   TCS,

---

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,

---

How to Convert the columns into rows?

2 Answers  

---

I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.

8 Answers  

---