Answer Posted / svr

data stage 7.5.2 data stage 8.0.1

1-single execute system multiple execute system

2-here change aplly & capture Here SCD TYPES R USED
stages r used
3- file based repostry it is data based repository

What is the process of killing a job in datastage?

1067

---

table actions available in oracle connector?

1655

---

What is the method of removing duplicates, without the remove duplicate stage?

1079

---

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

2501

---

What are the some differences between 7.x and 8.x version of datastage?

1305

---

how to export or import the jobs in .ISX file

1250

---

What a datastage macro?

1101

---

What is difference between server jobs & parallel jobs?

1088

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1554

---

If you want to use a same piece of code in different jobs, how will you achieve this?

1323

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1128

---

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 the benefits of datastage?

1301

---

What is data partitioning?

1267

---

Explain the situation where you have applied SCD in your project?

2087

---