Answer Posted / shailesh

simplest solution that i can think of using ds8.1 pivot satge
seqfile--->pivot--->target

in pivot stage give the derivation for new_col as old_col,old_col,old_col,old_col,old_col (five times)
map it to target you will get the desired output

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

1278

---

What is the use of datastage designer?

1217

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2778

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2486

---

Define repository tables in datastage?

1200

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2263

---

How to implement complex jobs in data stage?

1156

---

What are the benefits of datastage?

1301

---

Define orabulk and bcp stages?

1170

---

What is the use of datastage director?

1068

---

Can you explain repository tables in datastage?

1452

---

Which algorithm you used for your hashfile?

1227

---

What is the difference between orabulk and bcp stages?

1068

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3180

---

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

1456

---