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.

What are the various kinds of the hash file?

0 Answers  

---

What is the difference between passive stage and active stage?

0 Answers  

---

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,

---

What is the difference between datastage and datastage tx?

0 Answers  

---

I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

1 Answers   Amdocs, TCS,

---

How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  

---

How can we do null handling in sequential files

3 Answers   Reliance,

---

Is possible to create skid in dim,fact tables?

0 Answers   NTT Data,

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,

---

Differentiate between datastage and datastage tx?

0 Answers  

---

Tell me the syntax of Configuration file?

1 Answers  

---