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.

0 Answers  

---

Explain entity, attribute and relationship in datastage?

0 Answers  

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

0 Answers   Polaris,

---

WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,

---

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

0 Answers  

---

create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid   salary   previoussalary 10      1000     null 20      2000     1000 30      3000     2000       40      4000     3000

5 Answers   Genpact,

---

What are some different alternative commands associated with "dsjob"?

0 Answers  

---

How and where you used hash file?

0 Answers  

---

when will you go for dataset and fileset?

2 Answers   Accenture,

---

How to convert table data into xml file using xml output stage? please explain step by step;

2 Answers   IBM,

---

What is the difference between passive stage and active stage?

0 Answers  

---

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

---