Answer Posted / satyam

using pivot satage you can get that target records dont bother ok you have to implement that ,otherwise transformer stage in also you can add one record in output colomns and implement thatderivation cell . ok i think it very useful to tour question

On which interface you will be working as a developer?

1108

---

how to abort the job its matain duplicates?

2628

---

What is the use of datastage director?

1080

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2783

---

What is datastage?

1135

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

985

---

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.

2958

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2339

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2491

---

what is the use of materialized view?

1644

---

Can you explain players in datastage?

1255

---

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?

2283

---

What are the different layers in the information server architecture?

1180

---

What is the use of datastage designer?

1230

---

What is the difference between server job and parallel jobs?

1204

---