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 is A Datastage?

2 Answers  

---

How to read multiple files using a single datastage job if files have the same metadata?

0 Answers  

---

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,

---

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

---

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,

---

How do u call shellscript/Batch file from DS?

4 Answers   HP,

---

what is mapping lookup

1 Answers  

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,

---

source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?

2 Answers   Wipro,

---

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,

---

HOW CAN WE SEE THE DATA IN DATASET?

12 Answers   IBM, TCS,

---

What is the difference between datastage and datastage tx?

0 Answers  

---