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.

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

4 Answers   Wipro,

---

How can we do null handling in sequential files?

3 Answers   Reliance,

---

What is the difference between Datastage 7.5 and 7.0?

0 Answers  

---

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

---

can explain wt is the pool for file.

1 Answers   CTS,

---

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

0 Answers   CGI,

---

source contains 2 columns comes to target 4 columns how

1 Answers   IBM,

---

What are some prerequisites for datastage?

0 Answers  

---

can we use sequential file as a lookup

7 Answers   Cognizant, Wipro,

---

what is meta data? Explain? Where it is used?

9 Answers  

---

How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  

---

i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

5 Answers   HSBC,

---