Answer Posted / ramachandra rao

first of all question is not clear

ok fine

if u take source as sequential file there is one option is
there i.e rownumcolumn use this option it will create
sequnce number.

2.use columngenerator also we used



Thanks
chandu-09538627859

What are constraints and derivations?

1178

---

Differentiate between operational datastage (ods) and data warehouse?

1185

---

What is a merge in datastage?

1276

---

in oracle target stage when we use load option and when we use upsert option?

2286

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2471

---

Nls stands for what in datastage?

1197

---

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 ?

2027

---

Difference between sequential file and data set?

1210

---

Define orabulk and bcp stages?

1129

---

What is the purpose of pivot stage?

1175

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1236

---

Define data aggregation?

1106

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1399

---

What are iconv and oconv?

1251

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2228

---