Types of OLAP’s in TeraData

Ratings:
(4)
Views:0
Banner-Img
  • Share this blog:

 

a) ROLAP(relation OLAP)

In this case data and aggregating stored under relational sources.

Example:   

tools used, Cognos, Bo, Crystal reports, SERS, etc  

b)MOLAP multi-dimensional OLAP

Here data aggregate store under multidimensional source(cubes)

Example:   

Cognos, SSRS, Hyperion, Microstrategy, etc

c) HOLAP(Hyperid OL AP)

Data in relation source and aggregate store multi-dimension source

Example:   

BO, Hyperion, Cognos etc

d) OLAP(DISK OLAP)

Data aggregate stored under Desktop Application sources as, ms-excel, Lotus, Notes, etc.

  OLAP  

ROLAP{ DAT AGGREGATION MOLAP{Date Aggregate

DATA---HOLAP---------Aggregate

Teradata server

Teradata Server

Inclined to build a profession as Teradata Developer? Then here is the blog post on, explore Teradata Training

Data Sources(ODBC)

Data sources  

 

Services

 

Services        

 

Teradata component when there usages

Teradata query submitting tools

SQL Assistant

[SQL Surya tech PAD in tera data 13]

BTEQ  

 

Teradata utilities

BTEQ

FAST LOAD

M LOAD(multi-load)

FAST export

T PUMP

Teradata Analyst pack

Teradata Index wizard

Teradata Statistics

Teradata System emulation tool etc

Teradata Visual explain

Tera data Administrator tools

Teradata Performance monitor

Teradata Administrator

Teradata Manage etc.  

Other RDBMS                                      Teradata

Starting: Green color                               Orange color

Stop: RED                                                  GREY    

 

Teradata submitting tools

Teradata Sql Assistant(query man) BTEQ(Basic Tera data query)
Navigation:1st  way: start2RUN-2query man(interact B(INTERADATA12)SQL A) Start2 programs-2Tera data client2 tera data BTEQ BTEQ win
2nd way: startà program2ID Sql Assistant Sql
  1. Start 2 Programs—
2Tera data client 2Tera data BIEQ/BTEQ
1.Wizard based(or) GUI Based 2.We can view the history here 3.we can set the color, the NWHS, multiple queries at a time, etc. 4.Mainly Designed for connection and firing any ODBC Complaint data base (Oracle, SQL Server, etc)related query and commands.  COMMAND mode N/A[NOT APPLICABLE] N/AMainly design for tera data related query and command.

Tera data database hierarchy

Parent Database/user

           ↓

DBC-(Database computer/controller)  

Teradata - OLAP    

Note: All permanent memory lived limits are subtracted, owner

A new database and user should be created, it’s parents(existing database of the user)

Permanent space currently not used is available use as temporary cons pool memory

Default Driver User  ID/Password Designed for
TD.ADMIN Dbc/dbc Administrator
TWM user TWM/TWM Workload managers
TD user TD user/TD user Normal users

Note:

Default IP Address And Server name

127.0.0.1                      Localhost  

Working with query man

Query man requires a driver to connect

Connecting:- Click

Machine data source

Select TD Admin(or)our own driver

Q1. Display the user who connects to the system

Ans: SELECT USER  

Execution

  1. Execute parallel option

Q2. Display the database currently use working with

Ans SELECT DATABASE

Q3. Query to display session ID, Account ID

Ans SELECT SESSION, Account  

Seeing the history

Working with tools

Options

These options are useful to provide customize setting query man level  

a) General

Display this string for NULL data values Display dates in this format

  General

B) Code Editor

Code, COMMAND, STRING Values, Numerates, etc.  

C) Query

þ Submit only the selected query text when high light these options are disabled to by default when installing tera data software for the first time. Until your unable, you con not highlighted query  

D) Maximum number of answer rows to display

D) Answer set:-

Screenshot_28  

E) Export/import

These are the options used at the time of importing and exporting the data

1. History

    • Here we do history related setting

2. File path

    •  There is the file path where query answer set, history, Lob, Blob data stores.

Opening for new query window for queries

Click new query  

Tile Mode

If the answer set follows by the query horizontally tile mode  

Cascade mode

If the answer set and query display is cascade format that is cascade mode  

Changing the password

Tools Menu Change password

Teradata transaction modes

Teradata Interview Questions

1.This is the default mode, Some people they are calling modes as tracks mode 1.ANSI mode is an explicit mode
2.BTET-Statement auto committed
  1. ANSI- need to commit, abort, Rollback explicitly.
  2. We can implement transaction by specifying BTET(OR)Begin transaction(or)end transaction
  3.It doesn’t allow begin transaction(or) end transaction(it fails)
EQ[Equal]NE(Not equal)GE(OR)GET[Grater than][grater than equal] LE(OR) LTE[less than][less than or equal] 4.<>(or)!=>,>=<,<=
5.Default table ”set” table 5.Default table ”multi set” table
6.It execute tera data query and command 6.It execute any ANSI complement database query:-[Oracle, SQL server-------]
7.BTET is not –case sensitive
  1. ANSI is case- sensitive

Note

To Go to BTET to ANSI SQL assistant viewàANSI SQL

So that we will able to see SQL assistant ANSI  

Multi statement request

Writing multiple SQL statements and operates, semicolon, is called Multi statement request.  

a)SEL*FROM Party; UPDATE PARTY SET P

code=100 where

pid=10; write lock                 Write lock  column name

Sel user: Insert into

Write          Write

The system applies to write lock on the two statements and execution

b) It applies Read lock and select statement will lock and insert statement.  

i) SEL*FROM PARTY

Up date party set party code=100 where pid=10;

Write Lock

ii) sel user; insert int-----------

Read lock  write lock

Data Dictionary

  • It contains metadata information[data about data] of object
  • It is integrated with a set of system tables
  • It is distributed across all amp’s like all tables
  • General access data dictionary information via views

Ex:- A)DBC. tables

B) DBC. Columns etc

Questions:

1) To display all database in the current database system

SEL*FROM DBC. DATABASES

2)To display all user in the current tera data system

SEL*FROM DBC. USERS

3) To display all objects in all database users

SEL*FROM DBC. DBC TABLES.  

Database Name Table Name Table Kind Version
Database Table(or)View (or) Macro (or) Procedure (or) TRIGGER   TV   M   P   G 1)initial2)-one time alter 3)2times alters.

  4.To display all table inside the database name DWH(OR)VINAYAKA

Wrong: SEL*FROM VINAYAKA. TABLES.

Current query

SEL*FROM DBC. Tables where database name=’ VINAYAKA’ and table kind = ‘T’  

5.Display all columns in the current data system

Select*From DBC. COLUMNS  

6.To display all tables where the column name party id, exists

Select*From DBC. Columns where column name=’PARTY ID’  

7)To display all the error messages and error code

Select*From DBC. Error msgs  

8) Display the indexes available in the current tera data system

Select*From DBC. INDICES

Note:- Index types and their meanings

Q – PPI                                                       N-bas index

P-Non PPI                                                  K-Primary key

S- SI                                                            J – Join Index  

9)To display table size in the current tera data system

Select*From DBC. TABLE SIRE  

10) To Display the information about space utilization

Select*From DBC. ALL SPACE  

11.To display information about disk spaces Select*From

DBC. DISK SPACES  

12.To display information about access rights

Select*From DBC. ALL RIGHTS  

13.Sel, parent, child

Select*From DBC. Children

Select*From DBC. Children x

For In-depth knowledge on Teradata click on:

About Author
Authorlogo
Name
TekSlate
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.