Answer Posted / siva

seq.file-->copy-->agg
! !secondary link
!.....>join-------->filter-->t1
primarylink !---->t2
agg:countrows
give condition in filter
count=1-->t1
count<>1-->t2

Why we use surrogate key?

1227

---

Explain the importance of surrogate key in data warehousing?

1185

---

What is ibm datastage flow designer?

1141

---

What are the various kinds of containers available in datastage?

1044

---

What are the types of views in datastage director?

1761

---

How many areas for files does datastage have?

1146

---

Define Merge?

1313

---

What is a merge?

1158

---

How many types of hash files are there?

1177

---

What is a quality stage in datastage tool?

1071

---

Explain usage analysis in datastage?

1158

---

what is use of SDR function?

5169

---

What are the repository tables in datastage?

1301

---

If you want to use a same piece of code in different jobs, how will you achieve this?

1274

---

How do you run datastage job from the command line?

1081

---