Scenario #$2$

Using the Source and Target tables listed below, describe how to use Informatica to load$/$maintain Address Dim $($type $2).$

Be certain to list the transformation types needed and a brief description of the required actions for the desired result.

Source Table Source Column Data Type

scr$\_$ADDRESS ADDRESS$\_$ID NUMBER

scr$\_$ADDRESS ADDR$\_$LINE$1$ VARCHAR$2(100)$

scr$\_$ADDRESS ADDR$\_$LINE$2$ VARCHAR$2(100)$

scr$\_$ADDRESS CITY VARCHAR$2(50)$

scr$\_$ADDRESS STATE CHAR$(2)$

scr$\_$ADDRESS ZIP VARCHAR$2(10)$

scr$\_$ADDRESS ADDRESS$\_$TYPE VARCHAR$2(20)$

scr$\_$ADDRESS PHONE$\_$NBR VARCHAR$2(12)$

Target Table Target Column Data Type

ADDRESS$\_$DIM ADDRESS$\_$DIM$\_$SID NUMBER

ADDRESS$\_$DIM ADDRESS$\_$ID NUMBER

ADDRESS$\_$DIM ADDR$\_$LINE$1$ VARCHAR$2(100)$

ADDRESS$\_$DIM ADDR$\_$LINE$2$ VARCHAR$2(100)$

ADDRESS$\_$DIM CITY VARCHAR$2(50)$

ADDRESS$\_$DIM STATE CHAR$(2)$

ADDRESS$\_$DIM ZIP VARCHAR$2(10)$

ADDRESS$\_$DIM ADDRESS$\_$TYPE VARCHAR$2(20)$

ADDRESS$\_$DIM PHONE$\_$NBR VARCHAR$2(12)$

ADDRESS$\_$DIM BEGIN$\_$EFF$\_$DATE DATE

ADDRESS$\_$DIM END$\_$EFF$\_$DATE DATE

ADDRESS$\_$DIM EFFECTIVE$\_$IND CHAR

ADDRESS$\_$DIM LOAD$\_$DATE DATE

ADDRESS$\_$DIM LAST$\_$UPDATE$\_$DATE DATE