Answer Posted / prasad

MadhavaReddy, who gave logic that is correct.

I tried, got exact result.

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

---

project Steps,hits, Project level HArd things,Solved methods?

2185

---

What all are the different way to run a job?

1140

---

What are stage variables?

1257

---

What is the difference between orabulk and bcp stages?

1076

---

which r the connectors used in san?

2231

---

whom do you report?

1986

---

what is the difference between == and eq in UNIX shell scripting?

1559

---

Notification Activity

1461

---

Describe the architecture of datastage?

1062

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2282

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3811

---

What are the different common services in datastage?

1337

---

CHANGE CAPTURE

1355

---

what is the use of materialized view?

1640

---