Easy Adoption, with more data and integration approach.

Works ok in many use cases, but you need to maintain a close relationship with the vendor or third party to ensure usability, performance and security. Excellent Performance and integration tool.

Pros

> Teradata is one of the most reliable RDBMS platforms available in the market > Teradata is a power house when it comes to hosting a large data warehouse with greater storage and faster processing power > Importing and exporting data is super easy with the teradata utilities > Teradata has a strong admin setup which helps keep your data safe using a sound layer of access control

Cons

> Teradata can get tangled up in multiple queries running simultaneously and result in a much delayed processing > I think the UI is still backdated and desperately needs a next gen look and feel

Best for Mainstream SQL query

As a former Decision Scientist, I have prior experience of using the Teradata. It was very fast and efficient for performing SQL queries. I would definitely recommend it.

Pros

The interface. The shortcuts. The ease of multiple tabs. The ease to import/export data. Speed. Explain function of code

Cons

Had to do shut down for some hours every friday for weekly maintenance

Using Teradata Uphill Battle

Pros

I understand that their customer service was good. We had a nice relationship with our representative, and we had high hopes of utilizing this program throughout our organization.

Cons

Extremely difficult to utilize for any amount of project management. Initially, our team tried to use it with plotting out all the approvals and review and such, and it was a nightmare. Way too difficult to learn.

Teradata importance in BI

I have been using teredata for last 4 years,the performance is really good. My client is using teradata to run our BI applications.

Pros

very easy to code

Cons

need some more performance

Convinent to use and easy to understand

For testing Some internal applications on huge data we are using Teradata along with other RDBMS tools for our Validations and Teradata is convinent for those applications and its convinent to connect to all Databases and its user friendly .what I observed is its Linearly scalable,can be expanded the database capacity by just adding more nodes to the existing database. It can handle multiple adhoc requests and many concurrent users.so feels better at high volume data warehouse work than the Teradata have designed a DW database for fast loading of huge data volumes and fast SQL querying. It is more specialized for DW It acts as a single data store that accepts a large number of concurrent request from multiple client applications. Feature like parallelism along with load distribution shared among several users Execution of complex queries