SMUG effects

On December 2nd I attended the SMUG(SAS Melbourne User Group) Meeting, the discussion was on the topic “Getting the data from Anywhere” by Flavio Giurco & Andrew Howell and also using SASTRACE to generate some logs which might help in understanding and optimizing the data access code. I decided to get a first-hand experience on this so I decided to use Teradata, MySQL and Access databases.

The reason for choosing Teradata is, for quite some time I have been longing to play with Teradata. During my 2yrs and 8 months tenure at IBM India, at the end of development phase we used to populate our application tables By pulling data from other applications and mostly these applications used Oracle. So I had my chance to write procedures to pull data from various applications . MySQL being open-source I had opportunities to play with it now and then, also last semester I had the opportunity of being the tutor for the subject “Business Information Systems Design” where we covered MySQL.

After learning the Data Warehouse concepts my interest in Teradata grew even more. But will I be able to try out the three, I doubt it because I have access to SAS only at the University where I may not be able to get Teradata installed. But however MySQL has been installed in some of the systems and MsAccess is there in all of them. The post about my experience in connecting to the database using SAS will follow but now its Teradata time.

I’m going to learn some basics in Teradata, in case if you are wondering who needs these basics when it is available on the internet at least I know two of them one is myself and the other is of course my friend ( Ganasekar ) ,he visits my blog now and then( like he visits my other blog kalvettu don’t ask me how many times a week..year would be appropriate) to see if I have written something political. Me I need not carry my laptop whenever I go to city for an interview. All i need is go to the Victorian state library and go through my blog.

Apart from the prime job of hunting for a job I am also planning to write about all the stupid things that I do to increase my expertise in some of the key areas like

SAS – Obvious the first and foremost ( Don’t forget Aiming to be BI Solution consultant in future)
Pentaho – An amazing opensource BI tool,took me by surprise by its capabilities but still finding it hard with Weka
Teradata – Till I get used to using it
SugarCRM & Compiere – To see what it takes to implement these

“Does anyone know the statistical techniques of identify the optimal number of clusters?”
I was asked in an interview and I could not answer.

Finally it’s time to get into Teradata I found the GUI of the Teradata interesting especially the SQL assistant but however like I tell my students its important to understand how to use help and decipher the syntax and here I am trying to do what I advised. For those of you who wanted to try Teradata you can download Teradata developer version from teradata.com

Teradata Create Database Syntax

Adopted From : Teradata (August 2009) SQL Data Definition Language Syntax and Examples
Teradata


Create Database Newdatabase from tduser as
permanent = 1000 bytes,
spool = 512 bytes,
temporary = 512 bytes,
account = ‘tduser’,
fallback,
journal,
default journal table = Newdatabase.backuptable;

I had plans to write about Create database and table today and finally I wrote my create database query and there it was.

Surprise: What happened!!! where is the results???

There it was showing some strange number 2644. Oh!!! its an error message!?
Error Message 2644

Double Click 2644 to see the error message in the window shown below
Error Message 2644

Then I tried the following options

Option1 : Removing the space section.

Create Database Newdatabase from tduser as
account = ‘tduser’,
fallback,
journal,
default journal table = Newdatabase.backuptable;

Results : Error Message Permanent space is mandatory

Option 2: Allocate 1 byte
Create Database Newdatabase1 from tduser as
permanent = 1 bytes,
account = ‘tduser’,
fallback,
journal,
default journal table = Newdatabase1.backuptable;

Result : Error 2644

Option 3: Allocate 0 bytes
Create Database Newdatabase1 from tduser as
permanent = 0 bytes,
account = ‘tduser’,
fallback,
journal,
default journal table = Newdatabase1.backuptable;

Result: Error 2644

Finally I tried creating the database using Teradata administrator. Without allocating any space I was able to create the database and then when I tried to move space from another database and again it gave error.At the end i was able to create only a database with 0 permanent space.

Any Solution !? and to KM experts am i in anyway near to story telling!!???

Advertisements