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
- 7094 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
What are routines in datastage? Enlist various types of routines.
Where do the datastage jobs get stored?
Can you explain engine tier in information server?
Define Merge?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the some differences between 7.x and 8.x version of datastage?
What is the precedence of stage variables,derivations, and constraints?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Define Data Stage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are some prerequisites for datastage?
in oracle target stage when we use load option and when we use upsert option?
What all are the different way to run a job?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Define oconv () and iconv () functions in datastage?
