Answer Posted / mamatha

APT_DUMP_SCORE provide details in the log output on how the framework partition the datasets, and the processes/partitioning that the operator are taking up.

This information is useful when you wish to observe the partitioning process of your job, and identifying potential bottlenecks on your job flow (especially tasks that are inserted by default by the framework).

What is the difference between datastage and datastage tx?

1114

---

What is the flow of loading data into fact & dimensional tables?

1108

---

What are transforms and what is the differenece between routines and transforms?

1104

---

What is the difference between operational data stage (ods) and data warehouse?

1292

---

Explain usage analysis in datastage?

1222

---

What is the difference between account and directory options ?

1232

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1278

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2110

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2518

---

Name the third party tools that can be used in datastage?

1134

---

What is the difference between hashfile and sequential file?

1314

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1428

---

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

2926

---

Define Routines and their types?

1257

---

What are the primary usages of datastage tool?

1128

---