Answer / Sony Jha

"There are two main types of hash files in DataStage: Hash join and Hash aggregate. A Hash join compares rows based on a hash value, while a Hash aggregate groups rows with the same hash value for further processing."n

What is the difference between orabulk and bcp stages?

1 Answers  

---

wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

---

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

---

How do you import and export the datastage jobs?

1 Answers  

---

explain about citrix scheduling tool in datastage

1 Answers   HSBC,

---

What is the difference between Link collector and Funnel Stages?

1 Answers  

---

what is combinability and non combinability?

2 Answers  

---

How to read multiple files using a single datastage job if files have the same metadata?

1 Answers  

---

What is the difference between SQl Loader and OCI in datastage?

2 Answers   CSC,

---

What is ibm datastage?

1 Answers  

---

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers  

---

What are system variables and sequencers in datastage

1 Answers  

---