Answer Posted / ds

In Stage variable:

stage_variable3 <map> stage_variable1
if column=stage_variable1 than 0 else 1 <map>
stage_variable2
column <map> stage_variable3

Put stage_variable2 as constrain to target stage.

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

1349

---

How many types of sorting methods are available in datastage?

1115

---

How can one find bugs in job sequence?

1494

---

What are the different common services in datastage?

1337

---

Name the different sorting methods in datastage.

1101

---

How many Key we can define in remove duplicate stage?

1442

---

What is a quality stage in datastage tool?

1128

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

969

---

What is difference between symmetric multiprocessing and massive parallel processing?

1199

---

how to add a new records into source?

2055

---

Describe the architecture of datastage?

1061

---

How to reverse the string using SQL?

1594

---

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.

2957

---

What are stage variables and constants?

1193

---

What is difference between server jobs & parallel jobs?

1089

---