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 to manage date conversion in Datastage?

0 Answers  

---

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno 1                                2 3 4 5 6 7 8 9 10                                                                                             

5 Answers   Tech Mahindra,

---

HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?

1 Answers   Infosys,

---

how to abort the job its matain duplicates?

0 Answers   TCS,

---

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  

---

---

INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?

11 Answers   CTS,

---

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers   ME,

---

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,

---

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,

---

i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?

4 Answers  

---

What are some different alternative commands associated with "dsjob"?

0 Answers  

---

can we half project in parallel jobs and half project in server jobs?

4 Answers   Infosys, L&T,

---