Answer Posted / shasank, pr3systems

use transforemr stage and give three stage variable with intial value as 0,
then give (if company=ibm then count=count+1 else stgvar1)
like give three conditions for remaing two companies in two stage variables)
and in column derivation give if company=ibm then stgvar1 else
if company=wipro then stgvar2 else if company=tcs then stgvar3 else 0(company not in list)

What are the steps required to kill the job in Datastage?

1216

---

Have you have ever worked in unix environment and why it is useful in datastage?

1129

---

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.

2897

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1109

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

2440

---

What is the difference between hashfile and sequential file?

1257

---

How to reverse the string using unix?

3503

---

What is apt_config in datastage?

1134

---

What are the functionalities of link collector?

1085

---

Which commands are used to import and export the datastage jobs?

1412

---

Differentiate between hash file and sequential file?

1068

---

Explain connectivity between datastage with datasources?

973

---

What are stage variables and constants?

1146

---

What is the difference between passive stage and active stage?

1530

---

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

1284

---