Answer / shar

Here are Uses:
1.We can generate sequence Numbers.
2.This will act as alternative to primary key.
3.we can pass the values with parameters.
4.we can pass the parameters at run time.
5.parameterization is possible.

cool...:)

Answer / vinod upputuri

Surrogate Key Stage is used to generate the Surrogate Key.

the main purpose of the Surrogate key is to maintain the
complete history in the dimension tables.

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

0 Answers  

---

How can we improve the performance in datastage?

0 Answers  

---

what is datastage job Monitoring

6 Answers   CTS,

---

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 Answers  

---

State the difference between an operational datastage and a data warehouse?

0 Answers  

---

how many write modes are there in ds

2 Answers   IBM,

---

in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

1 Answers   IBM,

---

What are the steps needed to create a simple basic datastage job?

0 Answers  

---

what is materialized view used datastage?

1 Answers   HSBC,

---

Demonstrate experience in maintaining quality process standards?

0 Answers   iGate,

---

How you can fix the truncated data error in datastage?

0 Answers  

---

source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

6 Answers   US Technology,

---