Interested to Buy Any Domain ? << Click Here >> for more details...
diff between OLTP and OLAP?
what TOP-DOWN and BOTTOM-UP Approach? which is best?
what are Star Schema and Snow Flake Schema?
- 2 Answers
- 7117 Views
- TCS, I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define meta stage?
what is flow of project?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is the project in datastage?
State the difference between an operational datastage and a data warehouse?
What are the types of containers?
how to add a new records into source?
Can we use target hash file as a lookup ?
What is the difference between server job and parallel jobs?
What is the roundrobin collector?
What is job control?
What is the difference between an operational datastage and a data warehouse?
On which Dimension Table you implemented SCD Type in your Project
How a source file is populated?
Differentiate between operational datastage (ods) and data warehouse?
