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 file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,

---

Triggers,VIEW,Procedures

0 Answers   CTS,

---

What are the areas of application?

0 Answers  

---

How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,

---

how to create document in datastage?

1 Answers   Cap Gemini,

---

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

3 Answers   Accenture,

---

how to closeing records after 10,000 records come?

3 Answers  

---

What are stage variables and constants?

0 Answers  

---

what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,

---

How do you start developing a datastage project?

0 Answers  

---

How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition

6 Answers   TCS,

---

How do you get log info into a file?

1 Answers  

---