Answer Posted / prasad

If the source is Oracle,or any Rdbms then use the 'where
clause' option in the 'available properties to add' tab
other wise we can done using 'filter or transformer'

Define Routines and their types?

1192

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5126

---

Differentiate between hash file and sequential file?

1076

---

Is the value of staging variable stored temporarily or permanently?

1004

---

EXPLAIN SCD

1412

---

What are the areas of application?

1152

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2295

---

In Datastage, how you can fix the truncated data error?

1163

---

What are the differences between datastage and informatica?

1180

---

what is the use of materialized view?

1575

---

Describe routines in datastage? Enlist various types of routines.

1016

---

Is possible to create skid in dim,fact tables?

2641

---

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?

2213

---

What is the different type of jobs in datastage?

982

---

Can you explain engine tier in information server?

1137

---