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

Differentiate between validated and Compiled in the Datastage?

1355

---

I have a few records just I want to store data in to targets cycling way how?

2414

---

How do you generate sequence number in datastage?

1140

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2212

---

How do you import and export the datastage jobs?

1209

---

Difference between in process and inter process?

1305

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1548

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

969

---

explain about citrix scheduling tool in datastage

2509

---

what is use of SDR function?

5225

---

Difference between server jobs & parallel jobs?

1130

---

How the ipc stage work?

1170

---

What is the difference between an operational datastage and a data warehouse?

1210

---

Explain usage analysis in datastage?

1224

---

What is the project in datastage?

1165

---