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

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

1088

---

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?

2156

---

What is size of a transaction and an array means in a datastage?

1237

---

How the ipc stage work?

1078

---

What is a merge?

1076

---

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)

2659

---

Where do you see different stages in the designer?

1034

---

What are the difference types of stages?

1134

---

What are the types of jobs we have in datastage?

1021

---

What is active and passive stage?

1360

---

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

1190

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3264

---

What are the types of containers in datastage?

1143

---

What are the functionalities of link partitioner and link collector?

950

---

whom do you report?

1879

---