Data warehousing with Teradata
Monday, March 7, 2011
what is an Enterprise Data Model (EDM)?
An enterprise data model (EDM) contains entities, attributes, and relationships that represent the information needs of the entire enterprise.
what is Erwin Data Modeler?
ERwin is a visual data modeling tool that supports logical and physical data modeling.
ERwin is a graphical data modeling tool that allows a modeler to use information requirements and business rules to create a logical and physical data model
ERwin is a graphical data modeling tool that allows a modeler to use information requirements and business rules to create a logical and physical data model
defien data warehouse?
A data warehouse is a decisional database system.
It is designed to support the decision makers in the organization in ways a transactional processing system is ill-equipped to handle, such as the strategic-level goals and visions of an organization.
It is designed to support the decision makers in the organization in ways a transactional processing system is ill-equipped to handle, such as the strategic-level goals and visions of an organization.
what is oracle warehouse builder?
The Oracle Warehouse Builder (OWB) is a tool provided by Oracle that can be used at every stage of the implementation of a data warehouse right from the initial design and creation of the table structure to ETL and data-quality auditing.
Wednesday, March 2, 2011
Permanet Journals work along with Backup to make it useful?
True
Permanent Journal tables work along with Archive options.
When DBA archives or backup Permanent journal its current
contents will be deleted
Permanent Journal tables work along with Archive options.
When DBA archives or backup Permanent journal its current
contents will be deleted
We create a journal / journal table at creation of table?
False.
Journal or Journal table is created at creation time of database
or users. we can also create these using MODIFY statement of
database or user.
At table creation time we just specify
1. Enable or disable journaling for that table
2. which journaling table to be used
3. what type of journaling to be used(Before / After/ Dual Before / Dual After)
Journal or Journal table is created at creation time of database
or users. we can also create these using MODIFY statement of
database or user.
At table creation time we just specify
1. Enable or disable journaling for that table
2. which journaling table to be used
3. what type of journaling to be used(Before / After/ Dual Before / Dual After)
what is a permanent journal and explain different types?
A Permanent Journal captures a picture of any row that changes. This would include UPDATES, INSERTS, and DELETES. Permanent Journals do not double the data or PERM for a table, but only doubles the rows that change.
i.e
The Permanent Journal stores only images of rows that have been changed due to an INSERT, UPDATE, or DELETE command.
There are four image options for the Permanent Journal:
· Before Journal
· After Journal
· Dual Before Journal
· Dual After Journal
i.e
The Permanent Journal stores only images of rows that have been changed due to an INSERT, UPDATE, or DELETE command.
There are four image options for the Permanent Journal:
· Before Journal
· After Journal
· Dual Before Journal
· Dual After Journal
Subscribe to:
Posts (Atom)