ER or Dimensional Model?

UDA
Enthusiast

ER or Dimensional Model?

Hey Folks

Just wanted to know, what type of model would you design, if you are implementing data mart in Teradata? NCR Teradata recommends ER model, normalized upto 3rd normal form..

Is there any documents on this? Where can I find more informations about this?

Thanks for your time.
2 REPLIES
Enthusiast

Re: ER or Dimensional Model?

You can find more on this in the Database design document.
Enthusiast

Re: ER or Dimensional Model?

Teradata has certain logical models which is in 3NF.
for banking,insurance and investment they have Teradata financial logical and for communication they have TD communication LDM...these data model will have 10 subject areas..eg: party,event,agreement and so on...we can use this datamodel for datawarehouse and we can implement the same model for datamarts..its up to our requirement...I hope these documents are more confidential...if ur comp implements the LDM then u will have the document...otherwise its very difficult to get