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.

EXPLAIN SCD

0 Answers   CTS,

---

what are fact tables and dimension tables? give example assuming one table.

3 Answers   IBM,

---

How the ipc stage work?

0 Answers  

---

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

0 Answers   IBM,

---

---

Why we need datasets ratherthan sequential files?

5 Answers  

---

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

5 Answers   Gallega, TCS,

---

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?

4 Answers   HCL,

---

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

0 Answers   Syntel,

---

How to perform incremental load in datastage?

0 Answers  

---

What is the default padding character?

3 Answers   IBM,

---