Answer / tanmay kumar meher

An ODS is an environment that pulls together, validates,
cleanses and integrates data from disparate source
application systems. Thisbecomes the foundation for
providing the end-user community with an integrated view of
enterprise data to enable users anywhere in the
organisation to access information for strategic and/or
tactical decision support, day-to-day operations and
management reporting.

The defination of Data Warehouse is as follows.
? Subject-oriented, meaning that the data in the
database is organized so that all the data elements
relating to the same real-world event or object are linked
together;
? Time-variant, meaning that the changes to the data
in the database are tracked and recorded so that reports
can be produced showing changes over time;
? Non-volatile, meaning that data in the database is
never over-written or deleted, but retained for future
reporting;
? Integrated, meaning that the database contains data
from most or all of an organization's operational
applications, and that this data is made consistent.

Difference
------------
Ods
--------
Transactions similar to those of an
Online Transaction Processing System
Data Warehouse
--------------
Queries process larger volumes of data
Ods
--------
Contains current and near current data
Data Warehouse
------------
Contains historical data
Ods
-----------
Typically detailed data only, often
resulting in very large data volumes
Data Warehouse
--------------
Contains summarised and detailed data,
generally smaller in size than on ODS

Ods
--------
Real-time and near real-time data loads
Data Warehouse
------------
Typically batch data loads

Ods
--------
Generally modeled to support rapid data
update
Data Warehouse
-----------------
Generally dimensionally modeled and
tunes to optimise query performance
Ods
------
Updated at the data field leve
Data Warehouse
---------------
Data is appended, not updated
Ods
-------
Used for detailed decision making and
operational reporting
Data Warehouse
----------------
Used for ling-term decision making and
management reporting

Ods
-----
Knowledge workers (customer service
representatives, line managers)
Data Warehouse
-------------
Strategic audience (executives, business
unit management)

What are the data marts?

0 Answers  

---

What are the different models used in cluster analysis?

0 Answers  

---

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 are the different types of Fatcs? Explain with example only

3 Answers   CTS,

---

What are the data types present in bo? What happens if we implement view in the designer n report?

0 Answers  

---

What is a source qualifier?

0 Answers  

---

How can we load the time dimension?

0 Answers  

---

if source contain 10records how you identify header and footer

2 Answers   Polaris,

---

What is a data profile?

0 Answers  

---

Compare aggregates and data marts

0 Answers   TCS,

---

Explain the importance of data warehouse?

0 Answers  

---

What are Data Marts?

2 Answers  

---