Maximum number of tables in a Database

General
Enthusiast

Maximum number of tables in a Database

Hi, Could anyone please tell me how many maximum number of base tables we can create in one Database in TD12.

Thank you

Tags (2)
4 REPLIES
Enthusiast

Re: Maximum number of tables in a Database

There is no defined limit to the number of tables in a database.
Enthusiast

Re: Maximum number of tables in a Database

Awesome !! Thanks Jim...

Re: Maximum number of tables in a Database

Hello,

I'm new to Data Warehousing and a fresher. I've a plan to take an Oracle certification followed by a Teradata professional certification.

So, looking forward, whether I should take 'Oracle certified Associate' or 'Teradata certified Professional' certification first... and the value of Oracle Certifications in near future..

Please help..

thanks,

Yogesh

Teradata Employee

Re: Maximum number of tables in a Database

Hi Yogesh,

I would say it depends on the EDW strategy of the companies / projects you will work for. For full EDW implementations then the Teradata certification is a great asset as Big Data analytics, full enterprise consolidation and heavy-load BI applications run best on Teradata systems (which will probably be the best option). For small-scale data-marts and databases some companies go for other DB systems first before they decide to move forward to the Teradata analytical platforms. In this case, it might be reasonable to get certifications in the system you will work with first then delay the Teradata Certification until it is needed for EDW projects.