Answer / navin

DW is for to maintain historical & current data.
if use Natural key as primary key in DW we can't maintain
history.so we need a physical key in DW i.e is generated by
ETL developer .In DW we have develop a key called surrogate
key.

Answer / pavani

we used the surrogate key for the sequence(for files in order)
ex we save one dummy value in some text file that dummy
value is surrogate key value when ever we are using the
surrogate stage we have to use that file for sequence order

Answer / shiva

WE DONT USE PRODUCTION KEYs IN OUR DW, SO WE GENERATE OUR
OWN KEYS TO IMPLIMENT DW USING THIS SUROGATE KEY.

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,

---

what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

---

What is process model?

0 Answers  

---

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers  

---

what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---

What are the types of views in datastage director?

0 Answers  

---

Define Merge?

0 Answers  

---

What is the difference between lookup and sparse lookup?

1 Answers  

---

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers   L&T,

---

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

---

i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers   IBM,

---