what is the difference between DSS and ODS ?
Answers were Sorted based on User's Feedback
Answer / naidu
ODS DSS
1.it is designed to support 1.it is designed to support
operational monitoring decision making process
2.Data is volatile 2.Data is non-volatli
3.Current data 3.Historical data
4.Detailed data 4.Summary data
| Is This Answer Correct ? | 31 Yes | 0 No |
Answer / swamy.l.n
NAIDU ANSWERS &
ODS DSS
1.IT IS INTIGRATED DATABASE 1.INTIGRATED DATABASE
2.IT IS SUBJECT ORIENTED 2.SUBJECT ORIENTED
| Is This Answer Correct ? | 6 Yes | 29 No |
Explain what are non-additive facts in detail?
How do you define data block size?
Explain what is ods (operation data source)?
Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 Answers Principal Finance, PT Metalogix Infolink Persada,
What is difference between Business Objects and Hyperion Essbase? Please help me
What is data type of the surrogate key?
What is cubes?
What is difference macros and prompts?
what is indexing ? what are different types of indexes supported by oracle ?
Explain what are the different types of data warehousing?
What are the different types of join operations?
Code the tables statement for a single-level (most common) frequency?