Answer Posted / s

agg-->filter-->trg2
^ |
| v
seq-->copy-->join-->trg1

agg:countrows
join:innerjoin
filter:count=1
:count>1

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1349

---

Can you explain players in datastage?

1247

---

What are the steps needed to create a simple basic datastage job?

1305

---

What is difference between server jobs & parallel jobs?

1088

---

How you Implemented SCD Type 1 & Type 2 in your project?

4179

---

how can we create rank using datastage?what is the meaning of rank?

8856

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2928

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1114

---

Is possible to create skid in dim,fact tables?

2691

---

How one source columns or rows to be loaded in to two different tables?

1174

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2139

---

How to implement complex jobs in data stage?

1159

---

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

1299

---

What are the various kinds of the hash file?

1195

---

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

1342

---