All Forums Data Modeling
madasameee 2 posts Joined 03/14
24 Mar 2014
Novice seeking help for teradata EDW modelling

Hi Everyone,
Good that i got this forum on the second day of my learning itself, not so late!! I have been with Oracle DWH, Informatica, Obiee and siebel for around five years and now seeking a change to Teradata EDW Modelling
I know the basics of DW modelling, but never have really seen how the EDWs in teradata looks alike. Is there anywayi start working on them immediately apart from Express edition that is available for Vmware. 
Please help me on this regard. And you may please highlight points that i should keep in mind during the course like those utilities and etc.
 

Thanks, Madasamy M.
Raja_KT 1246 posts Joined 07/09
25 Mar 2014

Teradata is MPP architecture. Try to see its beauty employing your  business cases.Utilities like bteq,mload,tpump,
fastload,fastexport, tpt are at hands.Initially,maybe you can try with employee and department tables(model) , implementing indexes etc.You can inch towards its other tools and integration... UDA etc... 
There are some sample db objects ( examples)  too available.
Cheers,

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

madasameee 2 posts Joined 03/14
27 Mar 2014

Thanks Raja. Any other help would be appreciated as well :) 
I am going through each one of you have mentioned. 

Thanks,
Madasamy M.

Adeel Chaudhry 773 posts Joined 04/08
09 Apr 2014

As far as data-modelling is concerned, 3NF is suggested and you can use star or snow-flake style.
 
The only part that you would find new is the way how indexes work. So you should gather knowledge around this area. The concept is is different than PKs. Once you are aware of how it works, you can surely model in a seemless way.

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.