1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

diff between OLTP and OLAP?
what TOP-DOWN and BOTTOM-UP Approach? which is best?
what are Star Schema and Snow Flake Schema?

Question Posted / subbuchamala

Answers were Sorted based on User's Feedback



diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Sch..

Answer / 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

Is This Answer Correct ?    1 Yes 0 No

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Sch..

Answer / 8686865797

OLTP databases are highly Normalized relational databases & OLAP databases are highly De normalized.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Data Stage Interview Questions

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers   EDS,

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

0 Answers   TCS,

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  




What are the types of views in datastage director?

0 Answers  

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers   Alpharithm Technologies,

6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment

3 Answers   TCS,

What are the main differences you have observed between 7.x and 8.x version of datastage?

0 Answers  

How many types of views are there in a datastage director?

0 Answers  

Why we use surrogate key?

0 Answers  

count number of deptno in a emp table?

2 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories