Teradata Benefits

SurjitChoudhury - PeerSpot reviewer
Data engineer at Cocos pt

We created and constructed the warehouse. We used multiple loading processes like MultiLoad, FastLoad, and Teradata Pump. But those are loading processes, and Teradata is a powerful tool because if we consider older technologies, its architecture with nodes, virtual processes, and nodes is a unique concept. 

Later, other technologies like Informatica also adopted the concept of nodes from Informatica PowerCenter version 7.x. Previously, it was a client-server architecture, but later, it changed to the nodes concept. Like, we can have the database available 24/7, 365 days. If one node fails, other nodes can take care of it. Informatica adopted all those concepts when it changed its architecture. Even Oracle databases have since adapted their architecture to them. 

However, this particular Teradata company initially started with its own different type of architecture, which major companies later adopted.

It has grown now, but initially, whatever query we sent it would be mapped into a particular component. After that, it goes to the virtual processor and down to the disk, where the actual physical data is loaded. 

So, in between, there's a map, which acts like a data dictionary. It also holds information about each piece of data, where it's loaded, and on which particular virtual processor or node the data resides. Because Teradata comes with a four-node architecture, or however many nodes we choose, the cost is determined by that initially. So, what type of data does each and every node hold? It's a shared-no architecture. 

So, whatever task is given to a virtual processor it will be processed. If there's a failure, then it will be taken care of by another virtual processor.

Moreover, this solution has impacted the query time and data performance. 

In Teradata, there's a lot of joining, partitioning, and indexing of records. There are primary and secondary indexes, hash indexing, and other indexing processes.

To improve query performance, we first analyze the query and tune it. If a join needs a secondary index, which plays a major role in filtering records, we might reconstruct that particular table with the secondary index.

This tuning involves partitioning and indexing. We use these tools and technologies to fine-tune performance.

When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration. But, these technologies are quite old now. 

With newer big data technologies, we've worked with a four-layer architecture, pulling data from Hadoop Lake to Teradata. We configure Teradata with the appropriate hostname and credentials, and use BTEQ queries to load data. 

Previously, we converted the data warehouse to a CLD model as per Teradata's standardized procedures, moving from an ETL to an EMT process. This allowed us to perform gap analysis on missing entities based on the model and retrieve them from the source system again. We found Teradata integration straightforward and compatible with other tools.

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

Teradata has helped our organization accelerate substantially the decision-making that happens.

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

It is the core of our fundamental real-time reporting and operational planning. It has saved us over eight figures in the operational run costs, improved data quality and consistency as well as reduced our overall infrastructure support requirements.

View full review »
Buyer's Guide
Teradata
March 2024
Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.
AK
Teradata Team Leader at a financial services firm with 1,001-5,000 employees

With the current machine we are able to eliminate the use of OLAP cubes and allow customer queries to run directly on the Teradata machine.

We have now started running more profit generating activities on the Teradata machine, as opposed to just running reports, as in the past.

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

It has massive parallel processing ability to do large amounts of concurrent querying. It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs.

View full review »
it_user291063 - PeerSpot reviewer
Lead Teradata DBA at a manufacturing company with 10,001+ employees

Our business processes are much more efficient with Teradata's speed.

View full review »
it_user6057 - PeerSpot reviewer
Senior Java Developer at EPAM Systems at a tech vendor with 10,001+ employees

Improved performance of ETL procedures, reporting. Decreased efforts, time, and number of staff supporting DWH.

View full review »
SD
Solution Lead at a tech company with 10,001+ employees

Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services.

Teradata has proven technology with significant advantages in some key areas, and greater depth and experience in providing industry knowledge and solutions.

View full review »
it_user710166 - PeerSpot reviewer
Operations Manager at a tech services company with 10,001+ employees

Things have started moving faster in my company, such as data retrieval happens more quickly.

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

Our enterprise data warehouse (EDW) runs on Teradata and it is the single version of truth for management decision-making and reporting.

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

Basically, Teradata has allowed the multiple businesses that I have consulted for to build and store their Data Warehouse related data efficiently. It also serves up the data quickly, if tuned and organized properly.

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

Technically, it has made data processing much faster than other SMP databases.

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

It has allowed our organization, a retail company, to focus on timely marketing campaigns for the proper customers.

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

We have improved our daily/monthly reporting, campaign management, and behavior analysis.

View full review »
it_user310206 - PeerSpot reviewer
Analyst at a tech services company with 10,001+ employees
  • Cuts time to process huge amounts of data with analytical queries
  • A conventional and easily defined way to build a data warehouse or a layer of data marts
  • Better development time - Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools
View full review »
it_user277488 - PeerSpot reviewer
Professional Services Senior Consultant at a tech services company

Vodafone Spain tried to migrate a very populated data mart platform from Sybase IQ to Oracle. Unfortunately, they failed at this job. But more than 20 Sybase IQ database engines (with their respective licence, support costs, etc.) were successfully integrated into one single Teradata ecosystem.

View full review »
it_user263427 - PeerSpot reviewer
EDW Lead at a tech services company with 1,001-5,000 employees

It's simple to use and scalable.

View full review »
it_user427224 - PeerSpot reviewer
Project Manager at a tech services company with 5,001-10,000 employees

Faster query response time.

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

Business, Analytics, Hybrid.

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

We are into DWBI (Data Warehousing and Business Intelligence) and Teradata is number one in the market for these solutions. They stood on top even for changing business needs and beat other competitors in benchmarking.

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

It didn't improve the way our organization functions.

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

As it is a data warehousing solution, many reporting sessions and users can run simultaneously without much performance degradation. The product is more helpful in historical analysis and customer behavior trends for the organisation.

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

Teradata has allowed us to provide an online BI solution that no other player was able to do.

View full review »
it_user777930 - PeerSpot reviewer
Director at a tech services company with 11-50 employees
  • Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information.
  • It has reduced a lot of reworking on maintaining indexes, partitions, etc. Due to its architecture, the focus has been shifted from not maintaining the database to how we can utilize the data/features.
View full review »
Buyer's Guide
Teradata
March 2024
Learn what your peers think about Teradata. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.