Answer Posted / hari

Hi Kpk

I Think u r answer correct in Oracle view but question is
how can we use the materilized views in dataStage.

My view is No need of materialized view in DataStage it can
be used in Reporting time ( in OLAP)

What are the different type of jobs in datastage?

1041

---

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

1375

---

How many types of sorting methods are available in datastage?

1067

---

Is it possible to query a hash file?

2004

---

How you can fix the truncated data error in datastage?

1783

---

describe the Steps to confiure a Qlogic switch

2382

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1146

---

Define ds designer?

1273

---

Have you used Unstructured data?

1314

---

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?

1496

---

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 ?

2017

---

How can you write parallel routines in datastage PX?

1011

---

What is use Array size in datastage

1775

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2275

---

In Datastage, how you can fix the truncated data error?

1155

---