Answer Posted / rajeshchunduri

in datastage 8.0.1 version we have a stage scd.
give new data i/p link to scd stage and old data link to
transformer and from transformer give it to scd. from scd we
ger to o/p links one is fact and other is dimension.now
update date comes to dimension table.

Explain the importance of surrogate key in data warehousing?

1193

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1008

---

What are the primary usages of datastage tool?

1075

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1220

---

What is "fatal error/rdbms code 3996" error?

1274

---

Distinguish between informatica & datastage. Which one would you choose and why?

1010

---

How a routine is called in datastage job?

1122

---

How do you run datastage job from the command line?

1094

---

Can you explain tagbatch restructure operator?

1185

---

Have you used Unstructured data?

1326

---

How many Key we can define in remove duplicate stage?

1390

---

What are the components of ascential data stage?

1191

---

Explain usage analysis in datastage?

1173

---

How can we improve the performance in datastage?

1107

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1150

---