HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers   L&T,

---

What are the features of datastage flow designer?

0 Answers  

---

what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

---

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,

---

What is the difference between datastage and datastage tx?

0 Answers  

---

What are the difference types of stages?

0 Answers  

---

options available in sequence job to run,validate?

0 Answers   CTS,

---

How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?

1 Answers   IBM,

---

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

2 Answers  

---

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---

What is the difference between odbc and drs stage?

0 Answers  

---

How to convert alpha Numeric values to alpha using functions?

1 Answers   CTS,

---