Teradata Valuable Features

SurjitChoudhury - PeerSpot reviewer
Data engineer at Cocos pt
BS
Solution Architect at Capgemini

The most valuable feature is parallel processing architecture. Teradata's capabilities enhance data management efficiency, support scalability, and contribute to faster query performance, enabling us to derive valuable insights and analytics.

View full review »
MedhaValvekar - PeerSpot reviewer
Sr Manager at Cognizant

There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems.

View full review »
Buyer's Guide
Teradata
April 2024
Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,236 professionals have used our research since 2012.
MartinPotgieter - PeerSpot reviewer
Services Manager at Bytes Systems Integration

The most valuable feature of Teradata was actually the fact that it controls everything on a database. It's very, very fast. The way that it operates, the way it was designed, is quick. Not one other system, even IBM, is working on the principle of how Teradata is working. Teradata system is like a multiprocessor. In an IBM system, if you send him a query, the one CPU will handle it, and it will do the query and it'll send it out again. With Teradata, if the one query is coming in, you've got 12 CPUs and 20 hard drives; that query will be handled, at the same time, by the 12 CPUs and the 20 hard drives to store and subtract the information. It's just a totally different way how Teradata is working, and due to that, the performance of Teradata is extraordinary. There is no other system in the world that compares to it.

View full review »
Asish Sahu - PeerSpot reviewer
SPM at Infosys

The ability to handle machine data parallel processing is the most valuable feature of Teradata. The fundamental design concept involves moving from Oracle's design process to achieving the best possible design. This represents a departure from traditional approaches and is an innovative idea introduced by Teradata in the industry. Many newer databases, such as Snowflake and Vertica, have adopted similar architectures.

View full review »
Rupal Sharma - PeerSpot reviewer
Data Architect at Three Ireland (Hutchison) - Infrastructure

It's the same as your visual database. I like the fast load feature for data, BTQ nd storage procedures are very good. They can avoid table locking, which is very good.

View full review »
NT
Data Engineer at a recreational facilities/services company with 10,001+ employees

Teradata is a great, industry-leading data warehousing product that has MPP architecture. In recent times, there have been many other products available in the cloud space. It has a lot of other features like linear scalability and unconditional parallelism.

View full review »
MG
Vice President IT Architecture at a comms service provider with 1,001-5,000 employees

Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable.

View full review »
Al Krause - PeerSpot reviewer
Managing Director at advanced business horizons

The solution is speedy and doesn't require much of a DBA team, it's kind of baked right into the product.

View full review »
JP
Data warehouse consultant at Profinit

The solution offers very good features. It's useful when you are working with data. 

The level of complexity is okay.

It can handle very large amounts of data. It is very powerful. 

Designing the database is easy.

The solution is stable.

It is easy to set up.

The scalability is good. 

Technical support was fine to deal with.

View full review »
Blaine VandeBerg - PeerSpot reviewer
Principal at Insight Data Consulting

The most valuable features of Teradata are that it is a massively parallel platform and I can receive a lot of data and get the queries out correctly, especially if it's been appropriately designed. The native features make it very suitable for multiple large data tasks in a structured data environment. Additionally, the automation is very good.

View full review »
AM
Data Engineer III at a media company with 1,001-5,000 employees

Teradata's pretty fast. That is one very important aspect of the solution.

There are other tools, like Viewpoint, in Teradata, which is a monitoring tool.  

The integration is pretty easy here in Teradata.

It can scale.

We have found the solution to be stable. 

View full review »
Anton Van Heerden - PeerSpot reviewer
Managing Director at DNA Payroll Outsourcing

The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers.

View full review »
Rajdeep Biswas - PeerSpot reviewer
Technical Architect - Sr. Manager at Axtria - Ingenious Insights

Teradata's most valuable feature is that it's easy to use.

View full review »
SD
Test Engineer at cigniti

The performance is the key item we appreciate. We're able to easily trigger jobs and we have access to integrations for running jobs. It's easy to use for the most part, which is why I really like it.

It's stable and reliable.

I've never had any issues with scalability.

The initial setup is pretty simple to set up. 

View full review »
AY
Data Architect, Section Head at a energy/utilities company with 10,001+ employees

The loading time of the solution is quite good.

What really impressed me is their approach to design the data warehouse. It's very different from other solutions. They have their own methodologies for doing things, and they can come up with a very solid and good design that can stand the test of time.

The functionality of the solution is excellent.

The solution can scale.

It's quite a stable product.

On the product side, I don't think anyone can actually beat them with data warehousing.

View full review »
it_user525360 - PeerSpot reviewer
Enterprise Programmes Architect at a logistics company with 10,001+ employees

Each has its strengths and weaknesses; this is why we use a blended environment. We have a holistic view which is very mature and thus, it is impossible to give a concise answer.

However, converting the Teradata from a pure BI to an ODS has been our greatest achievement; it effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes.

View full review »
HM
Big data administrator at a comms service provider with 1,001-5,000 employees

Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available. 

View full review »
AK
Teradata Team Leader at a financial services firm with 1,001-5,000 employees

The two types of partitioning have been very significant for us - row and columnar partitioning.

View full review »
KA
Solution Sales and Lead Information at TechAccess Asia Distribution

Performance-wise, Teradata beats everything.

The flexibility in design is very good.

When you want to tune it, it is very easy to do. I have worked a lot as a DB and I know that when there is a query that is stuck for hours, and you want to tune it, the task is quite easy. You can use the indexes and architecture, and exploit the power of Teradata.

View full review »
AO
Operations Lead at a retailer with 201-500 employees

The availability is very good.

We have found performance to be one of the most valuable aspects. 

The solution scales well on the cloud. 

View full review »
NV
Business Intelligence Project Leader at NOUX C.A.

The most valuable feature is the ability to be anywhere - Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again.

View full review »
it_user845499 - PeerSpot reviewer
Manager Performance Systems at Telstra

Speed of complex queries and the ability to schedule give business users time to analyse data rather than waiting for queries to run.

View full review »
it_user291063 - PeerSpot reviewer
Lead Teradata DBA at a manufacturing company with 10,001+ employees
  • The ability to process large amounts of data very quickly
  • Its adaptability
View full review »
MR
Sr. Data Management Specialist at a computer software company with 1,001-5,000 employees

Teradata's best feature is its speed with historical data.

View full review »
it_user6057 - PeerSpot reviewer
Senior Java Developer at EPAM Systems at a tech vendor with 10,001+ employees
  • Scalability
  • Functionality
  • Performance
View full review »
SD
Solution Lead at a tech company with 10,001+ employees
  1. "Parallel Everything” design and smart Teradata Optimizer enables fast query execution across platforms.
  2. Fully parallel MPP “shared nothing” architecture scales linearly across data, users, and applications, providing consistent and predictable performance and growth.
  3. In-database data mining, virtual OLAP/cubes, geospatial and temporal analytics, custom and embedded services in an extensible open parallel framework, drive efficient and differentiated business insight.
  4. Workload management options by user, application, time of day, and CPU exceptions.
  5. Teradata Columnar/Teradata Temporal.
  6. Compress on cold and intelligent multi-temperature data management.
  7. Enhanced security.
  8. Customer driven innovation in application migration and temporal.
  9. Intelligent Scan Elimination.
View full review »
it_user710166 - PeerSpot reviewer
Operations Manager at a tech services company with 10,001+ employees

We really enjoy the FastLoad, TPump, and MultiLoad features.

View full review »
it_user689559 - PeerSpot reviewer
Senior IT Business Analyst at a comms service provider with 10,001+ employees

Viewpoint, the detailed query logs and performance statistics are valuable features. As a specialist for Teradata Performance, I find this data valuable for system tuning and query tuning.

View full review »
MH
Analytics Lead at a tech vendor with 10,001+ employees

It's very mature from as technology perspective.

View full review »
MP
Managing Director at a tech services company with 11-50 employees

Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running. 

View full review »
KG
Associate Manager at a consultancy with 501-1,000 employees

The performance is great, we are able to query our data in one operation.

View full review »
EK
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees

I like this solution's ease of design and the fact that its performance is quite good. It is stable as well.

View full review »
it_user718455 - PeerSpot reviewer
Business Analyst / Data Engineer

It is a solid database a lot of different tools to move data.

View full review »
Tejas Talele - PeerSpot reviewer
Software Engineer at a tech services company with 51-200 employees

The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security.

View full review »
NV
Business Intelligence Project Leader at NOUX C.A.

Our customers are very happy with the configuration. It's a pre-configured appliance that requires very little in terms of setting-up. 

View full review »
GM
Teradata FSLDM Consultant at TIK IT Solutions

The most valuable features are the Shared-nothing architecture and data protection functionality.

View full review »
RC
Associate Consultant at BT5 Business & Technology 5 Consulting

It handles large amounts of information with a linear performance increase, in relation to a HW investment. It has a solid set of tools and consulting services.

View full review »
MS
Senior Software Engineer at a tech services company with 201-500 employees

The most valuable feature of Teradata is the quick processing of large data.

View full review »
it_user702450 - PeerSpot reviewer
Manager BI Development at a comms service provider with 1,001-5,000 employees

Performance when processing terabytes of data.

View full review »
it_user310206 - PeerSpot reviewer
Analyst at a tech services company with 10,001+ employees

Efficiency of running analytical queries. Teradata was mainly invented for that purpose and it really does it well. We were able to migrate the code from SAS analytical platforms to pure Teradata and got an order of magnitude of performance growth (taking into account that the hardware was similar).

View full review »
it_user277488 - PeerSpot reviewer
Professional Services Senior Consultant at a tech services company

I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable.

View full review »
it_user263427 - PeerSpot reviewer
EDW Lead at a tech services company with 1,001-5,000 employees
  • It is simple for me as a developer
  • Query tuning is simple.
View full review »
it_user427224 - PeerSpot reviewer
Project Manager at a tech services company with 5,001-10,000 employees

Throttle

Columnar

View full review »
it_user692277 - PeerSpot reviewer
Teradata Consultant at a tech services company with 10,001+ employees

Stats, QueryGrid Autostats with collecting stats automatically with the threshold values assigned, QueryGrid has multiple new features i.e data migration, extraction, tool loading, other utilities.

View full review »
it_user685356 - PeerSpot reviewer
Teradata Architect at a tech services company with 501-1,000 employees

The optimizer is the most valuable feature for us.

View full review »
EB
Technical Manager at a energy/utilities company with 51-200 employees
it_user142503 - PeerSpot reviewer
SystemAnalyst

Auto-partitioning and indexing, and resource allocation on the fly.

View full review »
SM
Teradata DBA|Data Engineer Specialist|Hadoop Admin at a tech services company with 10,001+ employees

Good data warehousing solution. Workload Management (TASM) and Viewpoint.

View full review »
it_user1210803 - PeerSpot reviewer
Senior Consultant at a tech services company with 51-200 employees

Our customers are very impressed by Teradata's speed, because it's massively parallel processed. So you can get a great volume of data through quickly.

View full review »
it_user1076391 - PeerSpot reviewer
Auditor Federal de Finanças e Controle at CGU

The feature that we find most valuable is its ability to perform Massive Parallel Processing.

View full review »
it_user777930 - PeerSpot reviewer
Director at a tech services company with 11-50 employees

Parallel processing features have helped to easily dump any size of data and retrieve data with great performance.

Features like TPump were helpful for real-time data loads compatible with almost all other APIs/tools in our enterprise.

Inbuilt architecture reduces admins' efforts.

View full review »
Buyer's Guide
Teradata
April 2024
Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,236 professionals have used our research since 2012.