Answer Posted / syed naseruddin

materailized views are useful in two in datastage
1)when we are loading data from standard interface(staging
area) to dataware house
2)from datawarehose to reporting area


note:standard interface means---->in this arera we are
going to load the standerzie data using datastage from
differnet flat files and staging area.
on top of standerdized data we perform transformations


so,after performing transformations according to bussines
requirments we will load data to warehouse in between this
we material viwes to automatically referesh the data

same way when we are loading data from warehouse to
reporting purpose

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3644

---

What are the different layers in the information server architecture?

1122

---

What is the use of datastage director?

1012

---

how to abort the job its matain duplicates?

2572

---

What are stage variables, derivations and constants?

1218

---

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 ?

2016

---

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

930

---

Differentiate between datastage and datastage tx?

1045

---

Can you implement SCD2 using join, transformer and funnel stage?

1548

---

sed,awk,head

1459

---

What is a quality stage in datastage tool?

1071

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2621

---

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

1274

---

Explain Quality stage?

1145

---

What are the important features of datastage?

1119

---