• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Types of OLAP’s in TeraData

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.

 

Screenshot_21

 

ROLAP{ DAT AGGREGATION MOLAP{Date Aggregate

DATA—HOLAP———Aggregate

Teradata server

Screenshot_22

At TekSlate, we offer resources that help you in learning various IT courses. We avail both written
 material and demo video tutorials. To gain in-depth knowledge and be on par with practical
 experience, then explore Teradata Training.

Data Sources(ODBC)

Screenshot_23

 

Services

Screenshot_24

 

 

 

 

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 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 Data base/user

           ↓

DBC-(Data base computer/controller)

 

Screenshot_25

 

 

Note

All permanent memory lived limits are sub stracted owner

A New data base and user should be create, it’s parents(existing data base of user)

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

Default DriverUser  ID/PasswordDesigned for
TD.ADMINDbc/dbcAdministrator
TWM userTWM/TWMWork load managers
TD userTD user/TD userNormal users

 

Note

Default IP Address And Server name

127.0.0.1                      Local host

 

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 connect to system

AnsSELECT USER

 

Execution

  1. Screenshot_26

 

2.Display the data base currently use working with

Ans SELECT DATA BASE

3.Query to display session ID, Account ID

Ans SELECT SESSION, Account

 

Seeing the history

Working with tools

Options

This options are useful to provide customize setting query man level

 

a) General

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

 

Screenshot_27

B) Code Editor

Code, COMMAD, STRING Values, Numerates etc.

 

C) Query

þ Submit only the selected query text, when high lighte this options is disable to by default, when install tera data soft ware in first time. Until your unable, you con not highlighted query

 

D) Maximum number of answer rows to displayD) Answer set:-

Screenshot_28

 

E) Export/import

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

  1. History
    • Here we do history related setting
  1. File path
    •  There are 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

Screenshot_29

Learn more about Teradata Interview Questions in this blog post.
1.This is the default mode, Some people they are callingIs modes as tracks mode1.ANSI mode is explicit mode
2.BTET-Statement auto committed
  1. ANSI- need to commit, abort, Roll back explicity.
  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’s 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” table5.Default table ”multi set” table
6.It execute tera data query and command6.It execute any ANSI complement data base queryEX:-[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 statement and operates, semi colon, is called mutti 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

System applies write lock on the two statements and execution

b) It’s 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 contain meta data information[data about data] of object

It is integrate 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 current database system

SEL*FROM DBC. DATA BASES

2)To display all user in current tera data system

SEL*FROM DBC. USERS

3) To display all objects in all data base users

SEL*FROM DBC. DBC TABLES.

 

Database NameTable NameTable KindVersion
Data baseTable(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 data base name DWH(OR)VINAYAKA

Wrong: SEL*FROM VINAYAKA. TABLES.

Current query

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

 

5.Display all columns in 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 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 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 the information about access rights

Select*From DBC. ALL RIGTS

 

13.Sel, parent, child

Select*From DBC. Children

Select*From DBC. Children x

For Indepth knowledge on Teradata click on:

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Types of OLAP’s in TeraData"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.