Answer / nagaraz

surrogate key is an artificial identyfier for an entity.in
surrogate key are generated by the system sequentially.
primary key is a natural identifier for an entity.in
primary key are all the values are enterd manually by the
which are uniquely identifier there will be no repetion of
data

Answer / rajeshchunduri

surrogate key is identifier for the values in entity
generated by system.primary key is generated manually for
the values in entity

HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

1 Answers   HCL, IBM, Infosys,

---

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  

---

i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?

5 Answers   TCS,

---

How do you run datastage job from the command line?

0 Answers  

---

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  

---

---

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  

---

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,

---

How can we achive parallelism

1 Answers   CTS,

---

how can we do null handling in sequential files

2 Answers   Reliance,

---

how to call sequential generator in datastage?

1 Answers   IBM,

---

Define Routines and their types?

0 Answers  

---

What is the difference between hashfile and sequential file?

0 Answers  

---