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

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.

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

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)

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

Create a table with Fall back ,Before Journal and dual after journal features?

create table student ,
fallback,
before journal,
dual after journal
(
sno integer,
sname varchar(30),
sfee decimal(10,2)
)
unique primary index(sno);

what are the different image options for Permanent Journal?

There are four image options for the Permanent Journal:

· Before Journal

· After Journal

· Dual Before Journal

· Dual After Journal

Permanent Journals are automatically purged in teradata. True / False?

False.

The Permanent Journal must be manually purged from time to time.

which objects require Perm space in teradata?

Tables and Stored Procedures objects require Perm Space

Views, Macros , Triggers doesn't require Perm space.

Does Permanent Journals and Secondary indexes require Perm Space?

Ans: Yes

useful URLs?

http://www.coffingdw.com/Teradata_Basics/teradata_basics.htm#chapter_9___advanced_topics_that_you_will_be_tested_on/teradata_cabinets_nodes_vprocs_and_disks.htm