Answer Posted / kumar

go to partition--->select the partiton name other than auto-
-->check perform sort.

Explain entity, attribute and relationship in datastage?

1111

---

Define Routines and their types?

1193

---

How can one find bugs in job sequence?

1424

---

How a routine is called in datastage job?

1122

---

How do you start developing a datastage project?

1116

---

What is the difference between datastage and datastage tx?

1071

---

Differentiate between operational datastage (ods) and data warehouse?

1183

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2908

---

How do u convert the columns to rows in datastage?

1198

---

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

1384

---

Explain usage analysis in datastage?

1174

---

What is job control?

1120

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2188

---

Is possible to create skid in dim,fact tables?

2642

---

How to reverse the string using unix?

3516

---