Answer Posted / nagam

select count(*),empno from emp group by empno having count(*)>1;

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1726

---

What is the difference between validated and compiled in the datastage?

1261

---

Define Job control?

1118

---

What is the purpose of pivot stage and types of containers in datastage

1026

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1076

---

Can you explain players in datastage?

1174

---

Which algorithm you used for your hashfile?

1162

---

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

2847

---

Where do the datastage jobs get stored?

1189

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1192

---

What are sequencers?

1093

---

What are the areas of application?

1127

---

What is difference between join, merge and lookup stage?

1078

---

What is a folder? Difference types of stages?

1152

---

Can you explain engine tier in information server?

1108

---