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
- 7203 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
Can you implement SCD2 using join, transformer and funnel stage?
What are the steps required to kill the job in Datastage?
How do you reject records in a transformer?
What is the difference between odbc and drs stage?
What is the precedence of stage variables,derivations, and constraints?
What is a folder? Difference types of stages?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
what is the difference between == and eq in UNIX shell scripting?
What are the different kinds of views available in a datastage director?
How you can fix the truncated data error in datastage?
Can you define merge?
Where do the datastage jobs get stored?
What are data elements?
What are the repository tables in datastage?
What are some different alternative commands associated with "dsjob"?
