Sunday, 18 May 2014
Thursday, 1 May 2014
ODI USER FUNCTIONS
Exercise 2: Converting given Phone
Number in to smart phone format
Step1: Creating Flat File and reverse
engineer into Source Flat File Model
- Develop a flat file as shown and save as PHONE.txt
- Reverse engineer into source flat file model
- Change Phone column data type number to string
Step2: Creating Target table and reverse engineer into Target Model
- Develop a target table as shown below
- Reverse
engineer into target model
Step3: Creating project level user
function
- Under
RRITEC_PROJECT right click user functions à new user function
- Provide
name ,group and syntax as shown below
- Click
on implementations tab àClick on
'(' ||
SUBSTR($(PHONE),1,3)||') - ' ||SUBSTR($(PHONE),4,3) || '-' ||
SUBSTR($(PHONE),7,6)
- Click
on save and close
Step4: using user function in
interface
- Create a mapping with the name of m_ PHONE_FORMAT
- Drag and drop phone source table from RRITEC_FILE_MODEL
- Drag and drop RR_PHONE_FORMAT target table from RRITEC_TARGET_MODEL
- Connect Ename of source to ENAME of target
- Select target phone column and call user function PHONEFORMAT
- Select proper LKM and IKM
- Save >>> run
Subscribe to:
Posts (Atom)