Let's Learn Teradata Lesson 50: Hierarchy and Space

preview_player
Показать описание
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn how Teradata is Hierarchical!
  1. Coffing Data Warehousing
  2. Teradata Hierarchy
  3. Space hierarchy
  4. Coffing Data Warehousing
  5. Spool Space
  6. Permanent Space
Рекомендации по теме
Let's Learn Teradata 0:04:56

Let's Learn Teradata Lesson 50: Hierarchy and Space

Let's Learn SQL! 0:03:59

Let's Learn SQL! Lesson 50 : Using the ON COMMIT DELETE ROWS Statement in a Volatile Table

Let's Learn Teradata 0:02:47

Let's Learn Teradata Lesson 51: Database and Users

Let's Learn Teradata 0:03:57

Let's Learn Teradata Lesson 54: Amps and Joins

Let's Learn Teradata 0:06:28

Let's Learn Teradata Lesson 46: Spool Limits

Let's Learn Teradata 0:03:58

Let's Learn Teradata Lesson 56: Table Size and Data Movement in a Join

Let's Learn Teradata 0:05:56

Let's Learn Teradata Lesson 66: Introducing Fallback!

Let's Learn Teradata 0:02:46

Let's Learn Teradata Lesson 55: How do No Primary Index Tables Handle Joins

Snowflake+DBT+ADF+SQL Demo Online 2:01:24

Snowflake+DBT+ADF+SQL Demo Online Job-Based Training - SaiSri 10+ years of exp from RajCloudTech

Let's Learn Teradata 0:04:11

Let's Learn Teradata Lesson 53: How Data Moves with Joins

Let's Learn Teradata 0:04:09

Let's Learn Teradata Lesson 61: Partial Redistribution, Partial Duplication Strategy

Let's Learn Teradata 0:02:20

Let's Learn Teradata Lesson 47: Joins and Spool Limits

Let's Learn Teradata 0:06:36

Let's Learn Teradata Lesson 23: The Cylinder Index

Let's Learn Teradata 0:03:49

Let's Learn Teradata Lesson 49: Spool Space is Unused Permanent Space

Let's Learn Teradata 0:02:50

Let's Learn Teradata Lesson 89: Where the Collected Statistics Go

Let's Learn Teradata 0:05:54

Let's Learn Teradata Lesson 68: Introduction to Mirrors and Raid 1

Let's Learn Teradata 0:05:51

Let's Learn Teradata Lesson 65: FSGCache and Protection

Let's Learn Teradata 0:03:44

Let's Learn Teradata Lesson 44: Meet the DBC

Let's Learn Teradata 0:02:47

Let's Learn Teradata Lesson 14: Full Table Scans & PI Look Ups for Data Blocks

Let's Learn SQL! 0:04:10

Let's Learn SQL! Lesson 64: The Moving Average in OLAP with Teradata Syntax

Let's Learn Teradata 0:02:46

Let's Learn Teradata Lesson 31: Combining Old Data and New Data in a PPI

Teradata Interview Scenarios 0:38:39

Teradata Interview Scenarios Part 3 | Teradata Interview Questions and Answers

Let's Learn SQL! 0:02:58

Let's Learn SQL! Lesson 58: Order By and Group By With the Teradata Version of CSUM

Teradata Interview Scenarios 0:41:55

Teradata Interview Scenarios Part 2 | Teradata Interview Process | Interview Questions

Комментарии
Автор

Hello Tom,


I have one question regarding perm and spool spaces.I am still not clear regarding perm and spool space.Please help in understanding this.


In the slide at 3:09 sec it is said.Retail has 2 TB of perm and 100GB of spool space.


If there are 5 users assigned under Retail and all query up-to 100GB of spool simultaneously.So doesn't it meant that Retail has 100+100+100+100+100=500GB of spool in total?


Regrds.
Ayush.

proudindian