Teradata is used or has been used in past by most of the business enterprises. It processes of large amounts of data with ease. Easy to navigate and good graphic user interface Business users can also use it with basic training and query knowledge

Big data processing is a challenge due to its existing architectures. The cloud based option needs to be more affordable and at par with other service providers.

It's one of most powerful data integration and anaytics database solutions in the market today.

Teradata massive parallel processing gives advantage to other database for data integration and analytics. Query and reporting performance differentiate it with other comparable tools. Also, it offers customized SAP integration solutoin which eleiminates a needs for core SAP integration implementation. Teradata TPT and pushdown implemtation used with Informatica eleminates needs for performance tunning manpower and let end user access reports without performance issue.

The software is bit pricy and companies should move to cloud solutions wherever security is not a concern.

Basically we have started to using this teradata database version 15.0 in our application with the short name called "EDW" - Which implies Enterprise Data-warehouse in our healthcare project to store all our claims flow from Medicare, Medicaid and Membership information for the past 10 years and beyond. This is purely used an data warehouse where whole of our cpmpany operating with 60000 employees as its base since we are saving all our claims, providers, membership and broker/agents information. By short we are using in one of healthcare portal to get the information from data warehouse (Legacy informations).

Basically we have started to using this teradata database version 15.0 in our application. Some of the pros in using the teradata are: 1. Used for large data-sets and for ad-hoc queries. 2. Used for massive parallel processing (MPP) architecture like a single dataset table has been queried by multiple people and handling large volume of millions of rows. 3. It has a capability to expand a single data set in to enterprise wide. 4. It is fast in handling the queries for huge number of rows. 5. Good ROI since handling huge number of rows along with teradata support.

Since we are having advantages it is also having its own CONS (Disadvantages): 1. Query handling is little tougher which is different from SQL/T-SQL. 2. Price is higher (Huge) for smaller enterprise applications to handle the parallel queries data. 3. Not having its own tools like Oracle, SQL server, Sybase or any other DBMS to export/Import, reporting etc.,. Only third party told which is having OLEDB/ODBC having can be operated. 4. ROI is higher however the initial investment is more and in stable for smaller enterprise applications. 5. Not user friendly like SQL server/Oracle DBMS.

I highly recommend using this application

I like the advanced data management features, the artificial intelligence that is on the platform and its ability to manage multiple data

since I have been using it I have not yet found any complications with the platform

Highly scalable available vast prebuilt functionality like geospatial, json, xml types etc works well with hundreds terabytes ANSI SQl standard, available on AWS, Azure cloud.

cost is more than the other competitive RDBMS products. Teradata PS services are costlier. Teradata provides lots of Teradata specific functionality which other DBMS products may not have it,so migration from Teradata to other RDBMS may be challenging sometimes.