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

0 Answers   IBM,

---

What are routines in datastage? Enlist various types of routines.

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 u set a default value to a column if the column value is NULL?

7 Answers   HP,

---

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

---

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 Answers  

---

what is the main difference between sorragate key n primary key in one word

2 Answers  

---

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

---

how many rows sorted in sort stage by default in server jobs

0 Answers   Syntel,

---

how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,

---

How can we run same job in 1 day 2 times

4 Answers   IBM,

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,

---