Teradata is primarily used for data warehousing across all customers. My clients have built-in applications that use Teradata, and their use varies from customer to customer, depending on the industry and database size. The primary function is as an OLAP analytical ecosystem.
Team Leader for Data Base Administrators at a government with 1,001-5,000 employees
Real User
Top 10
2024-11-04T15:20:00Z
Nov 4, 2024
Our primary use case for Teradata is as a data warehouse; we store our databases for the data warehouse, including the EDW. It is mainly used for our data warehouse environment where we run a lot of analytics and heavy queries.
The use cases vary based on the projects. In most projects, I worked with ETL tools like Informatica alongside Teradata. However, there was a specific project where we built a real-time data warehouse for active directory data using Teradata. Oracle was the source system, with potential additional sources feeding into the Oracle database. We used Unix scripting to extract data from Oracle and leverage a colleague's expertise in Unix for the Teradata portion. We wrote ETL queries and performed data profiling before loading the data into the target data warehouse for further processing by other tools. Our task was to create a data warehouse, an active data warehouse in Teradata.
We used its capabilities for critical tasks, particularly in the realm of recovery jobs. We capitalized on the database's ability to transfer entire blocks of data rather than just transactional information. This approach, especially when dealing with block-level data, proved significantly faster compared to other techniques such as UBC WAN.
Teradata is a scalable data analytics platform designed to meet enterprise demands for large-scale data management and processing, focusing on performance, scalability, and security for complex query executions.As a leading data warehousing solution, Teradata integrates advanced analytics enabling organizations to derive insights from massive datasets. It supports high-volume data workloads with its architecture optimized for analytical queries. Users benefit from its robust scalability,...
Teradata is primarily used for data warehousing across all customers. My clients have built-in applications that use Teradata, and their use varies from customer to customer, depending on the industry and database size. The primary function is as an OLAP analytical ecosystem.
Our primary use case for Teradata is as a data warehouse; we store our databases for the data warehouse, including the EDW. It is mainly used for our data warehouse environment where we run a lot of analytics and heavy queries.
Our use cases were related to banks and other financial institutions.
I use the solution in my company for reporting.
The use cases vary based on the projects. In most projects, I worked with ETL tools like Informatica alongside Teradata. However, there was a specific project where we built a real-time data warehouse for active directory data using Teradata. Oracle was the source system, with potential additional sources feeding into the Oracle database. We used Unix scripting to extract data from Oracle and leverage a colleague's expertise in Unix for the Teradata portion. We wrote ETL queries and performed data profiling before loading the data into the target data warehouse for further processing by other tools. Our task was to create a data warehouse, an active data warehouse in Teradata.
We use Teradata IntelliFlex for data warehousing, which is a way of presenting data for faster retrieval.
We used its capabilities for critical tasks, particularly in the realm of recovery jobs. We capitalized on the database's ability to transfer entire blocks of data rather than just transactional information. This approach, especially when dealing with block-level data, proved significantly faster compared to other techniques such as UBC WAN.