Answer Posted / vijay sampoorna

oltp:
1) oltp has current and upated data
2)it is denarmalized
3)it has detailed data
4)it volatail
5) it is dynamic
OLAP:
1)it has current and histarical data
2) it is normalized
3) it has summarised data
4) it is non volatail
5) it is static
top down aproch;
first construct the enteir d.w.h then devided into data marts
Bottom down Aproch:
1)first build datamarts
2) then we build data where houses
star schema:
one fact table sorunded by one or more demintaion tables is calld star schema
it is use less memory
it performence is fast
it contain data duplicates
Snow-flake Schema:
one fact table soround by one or more demintion table that tables can splited into n dimentinos

Nls stands for what in datastage?

1141

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3604

---

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

1204

---

What are the types of views in datastage director?

1718

---

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

1972

---

How do you generate sequence number in datastage?

1025

---

How can you write parallel routines in datastage PX?

973

---

What is difference between server jobs & parallel jobs?

986

---

What is the difference between passive stage and active stage?

1410

---

What is the difference between in process and inter process?

1087

---

How do y read Sequential file from job control?

15791

---

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

886

---

Is the value of staging variable stored temporarily or permanently?

929

---

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

1292

---

Does datastage support slowly changing dimensions ?

1053

---