Merge - Example #1 - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
fcf1492702067123.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software
Parameterize a Merge analysis as follows:
  • Selected Columns
    • twm_customer_dqa.cust_id
    • twm_customer_dqa.income

      Rename income to inc by clicking on the selected column income and changing the name to inc

    • twm_customer_dqa.age
    • twm_customer.cust_id
    • twm_customer.income
    • twm_customer.age
  • Merge Style — Minus
  • Retain Duplicate Rows — No
  • Where Clause (both tables) — cust_id < 1362490

For this example, the Merge analysis generates the following results data:

Merge - Example #1 Data
cust_id income age
1360000 29592 29
1360001 27612 39
1360002 57612 49
1362480   33