PowerCenter
- PowerCenter 10.5
- All Products
Column
| Datatype
|
---|---|
CustID
| Integer
|
FullName
| String
|
Address
| String
|
Phone
| String
|
Fax
| String
|
CreatedDate
| Date
|
Email
| String
|
SSN
| String
|
CreditCard
| String
|
File
| Number of Records
| Fields
| Description
|
---|---|---|---|
Firstnames.dic
| 21,000
| SNO, Gender, Firstname
| Alphabetical list of first names. The serial number goes from 1 to 21,000. Gender indicates whether the name is male or female.
|
Surnames.dic
| 81,000
| SNO, Surname
| Alphabetical list of last names. The serial number goes from 1 to 81,000.
|
Address.dic
| 13,000
| SNO, Street, City, State, Zip, Country
| List of complete addresses. The serial number goes from 1 to 13,000.
|
Input Port
| Masking Type
| Masking Rules
| Description
| Output Destination
|
---|---|---|---|---|
CustID
| Key
| Seed = 934
| CustID is the primary key column. It must be masked with a random number that is repeatable and deterministic.
| Customers_Test
|
Randid1
| Random
| Range
Minimum = 0
Maximum = 21000
| Random number for first name lookup in the LKUP_Firstnames transformation.
| LKUP_Firstnames
|
Randid2
| Random
| Range
Minimum = 0
Maximum = 13000
| Random number for last name lookup in the LKUP_Surnames transformation.
| LKUP_Surnames
|
Randid3
| Random
| Range
Minimum = 0
Maximum = 81000
| Random number for address lookup in the LKUP_Address transformation.
| LKUP_Address
|
Phone
| Phone
| -
| Phone number has the same format as the source phone number.
| Customers_Test
|
Fax
| Phone
| -
| Phone number has the same format as the source phone number.
| Customers_Test
|
CreatedDate
| Random
| Blurring
Unit = Year
Low Bound = 1
High Bound = 1
| Random date that is within a year of the source year.
| Customers_Test
|
Email
| Email Address
| -
| Email address has the same format as the original.
| Customers_Test
|
SSN
| SSN
| -
| SSN is not in the highgroup.txt file.
| Customers_Test
|
CreditCard
| Credit Card
| -
| Credit card has the same first six digits as the source and has a valid checksum.
| Customers_Test
|
SNO = out_RANDID1
FIRSTNAME || ' ' || SURNAME