Uncategorized

Etl Testing Training Assignment

Etl Testing

“Etl Testing Training Assignment”

ETL Testing  – Mapping document exercise

 Training@H2KInfosys.com   www.H2KINFOSYS.com   H2KInfosys@Gmail.com

 

Source: SRC_CUSTOMER

Source Field or Column Name

Source Data Type

CUSTOMER_ID NUMBER(38)
CUSTOMER NAME INTEGER
ADDRESS NUMBER(38)
ZIPCODE VARCHAR2(16)
GENDER VARCHAR2(16)
DATE OF BIRTH TIMESTAMP(6)
PHONE NUMBER NUMBER(38)
LOYALTY ID NUMBER NUMBER(38)
RECORD CREATED ON TIMESTAMP(0)
RECORD CREATED BY VARCHAR2(30)

 

Transformation

Transformation
Straight copy
Straight copy
Straight copy
If zip_code in range (AAAA-BBBB) THEN EAST ZONE ELSE WEST ZONE
Straight copy
calculate age for date of birth
Straight copy
If loyalty id ends with 5 9’s then VIP customer else Non VIP customer
Straight copy
Straight copy

 

Target:TGT_CUSTOMER

Target Column Name

Datatype

UNQ Code

Nulls Allowed

CUSTOMER_ID INTEGER PK N
CUSTOMER NAME VARCHAR(40) Y
ADDRESS VARCHAR(46) Y
ZONE VARCHAR(20) Y
GENDER VARCHAR(20) Y
AGE INTEGER Y
PHONE NUMBER INTEGER Y
VIP_INDICATOR CHAR(1) Y
VERSION_START_DTTM TIMESTAMP(6) Y
VERSION_CREATED_BY_USR VARCHAR(50) Y

 

 

 Test Cases :-Generic

Test Case No.

Test Case Description

Test Case Passed

Comments

 

 

 Test Cases :-Business related transformations

Test Case No.

Test Case Description

Test Case Passed

Comments

1 Y/N
2 Y/N
3 Y/N
4 Y/N
5 Y/N

 

 Test Cases :-Performance Testing

Test Case No.

Test Case Description

Test Case Passed

Comments

1 Y/N
2 Y/N
3 Y/N
4 Y/N
5 Y/N

 

Facebook Comments
Tags

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also

Close
Close