What steps should be taken to improve Datastage jobs?

0 Answers  

---

What is a range lookup?

2 Answers   IBM,

---

SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 Answers  

---

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

0 Answers  

---

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

4 Answers   IBM, PR3 Systems,

---

How do you run datastage job from the command line?

0 Answers  

---

How do u convert the columns to rows in datastage?

0 Answers  

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,

---

How to reverse the string using SQL?

0 Answers   CTS,

---

1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

7 Answers   Wipro,

---

how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers   Wipro,

---

source contains 2 columns comes to target 4 columns how

1 Answers   IBM,

---