Answer Posted / subbu

2nd answer:

select * from(select rowid from tablename where rowid between 5 and 7);

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2940

---

What could be a data source system?

960

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2160

---

How can we improve performance of data stage jobs?

976

---

What is a merge in datastage?

1215

---

How a routine is called in datastage job?

1053

---

On which Dimension Table you implemented SCD Type in your Project

1976

---

How many types of hash files are there?

1133

---

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.

2851

---

What is staging variable?

1040

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1313

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1971

---

Why fact table is in normal form?

1161

---

Differentiate between odbc and drs stage?

1006

---

What is a folder? Difference types of stages?

1115

---