Top features of Teradata data mover for large data transfer

data mover

Teradata Data Mover

Moving data from one system to another is a key part of your analytical ecosystem operation. Well-planed, monitored, and managed data movement is essential to effective operation of your overall ecosystem.

Whether your goal is to complete a onetime copy of data from your enterprise data warehouse (EDW) to your test system or to regularly and continuously synchronize a dual system environment, you need confidence that the data will be in the right place at the right time while causing the smallest possible impact on the data warehouse’s mission of serving your business.

The decision about the best way to copy data between Teradata systems depends on many factors, including the data model and indexes present, other workloads in your system, and additional load jobs underway.

What you need is a solution that automates the data movement process, a solution that also accommodates the many situations found within your comprehensive analytical ecosystem. And that’s exactly what Teradata Data Movers delivers to you and your business; all the supporting capabilities you need to easily, effectively- and affordably- meet your data movement demands.

Intelligent Selection

Teradata Data Mover is a utility designed specifically to copy data and objects such as tables and statistics from one Teradata system to another. It takes advantages of the built-in underlying technologies already in your Teradata system. And it understands the available techniques you have for extracting data from or loading data into your Teradata Database, as well as our various load utilities, backup/restore product, and the JDBC driver.

Leverage Existing Technologies

  • Teradata Data Movers leverages all of the established data loading protocols and technologies to meet your needs and environment best.
  • You can use the utility for; Regular periodic tasks including populating a dependent datamart from an EDW.
  • Special one-time tasks such as moving data to a test system.
  • The utility also works with every member of our Teradata Purpose-Built Platform Family. In addition, it supports Teradata Database VZR6.1 and higher and runs.
  • On a Teradata Managed Server for high availability and comprehensive monitoring.

Comments

Post a Comment

Popular posts from this blog

SQL for Quantile Function in Teradata

Image
A Quantile is used to divide rows into a number of categories or grouping of roughly the same number of rows in each group. Quantile Function The percentile is the QUANTILE most commonly used in business. This means that the request is based on a value of 100 for the number of partitions SELECT Product_ID1, Sales_Date1, Daily_Sales1 ,QUANTILE(100, Daily_Sales1 ) AS "Quantile1" FROM Sales_Table WHERE Product_ID1 < 3000 AND Sales_Date1 > 1000930 ; The calculation is percentile for every row in the Sales table on Daily sales.
Read more

3 Uses of SAMPLE function in Teradata

Image
Usage-1 It returns a rows randomly from Teradata database. Syntax for SAMPLE function: SAMPLE [WITH REPLACEMENT]    [RANDOMIZED ALLOCATION]                  [WHEN <condition>  THEN]                  {<number-of-rows> | <percentage>}    […,<number-of-rows> | <percentage>]                  [ELSE {<number-of-rows> |    <percentage }   END] Usage 2 It allows the user to get absolute number of rows or percentage of rows. Usage 3 It also allows the rows to get from multiple samples How to get random rows from a table: SELECT * from sample_table SAMPLE 5; How to get certain percentage of rows: SELECT * from sample_table SAMPLE .30; How to get multiple SAMPLE data from a single tables with out duplicates: SELECT * from sample_table SAMPLE .20, SAMPLE .30 ORDER BY 1,2; SQL query to get 3 samples with duplicates: So 'WITH REPLACEMENT" you will get duplicate rows: SELECT ST_
Read more

Teradata Quick refresher for most popular Utilities

Image
Teradata utilities are very important while working with SQL and in data warehousing projects. The below short and crispy definitions help you can use while attending for interviews or in your day to day work to refresh your Teradata knowledge.  Top Teradata Utilities 1# MultiLoad  Inserts, updates, deletes, or upserts rows in a Teradata table by using the MLOAD command-line utility. It can handle multiple SQL statements in a single operation. You can provide user-defined SQL for complex operations. This stage is best used for bulk updates, deletes, upserts, and complex interface operations. 2# TPump  Inserts, updates, deletes, or upserts rows in a Teradata table using the TPUMP command-line utility. It can do concurrent updates on the same table. It can handle multiple SQL statements in a single operation. You can provide user-defined SQL for complex operations. 3# FastExport  Exports data from a Teradata table by using the FEXP command-line utility. You can customize i
Read more