raj arun BUSINESS RULE/MAPPING RULE TARGET Target Table Name DIRECT MAPPING CONTACTS_TGT10 319
DIRECT MAPPING DIRECT MAPPING DIRECT MAPPING CONCATENATE FIRST_NAME AND LAST_NAME CONCATENATE FIRST_NAME AND LAST_NAME WITH DOT IN BETWEEN GENERATE THE CURRENT SESSION NAME OF THE WORKFLOW GENERATE TODAY'S DATE CALCULTE EMAIL ID LENGTH GENERATE LAST DATE OF CURRENT MONTH ASE ADMINISTRATOR RAJ V RAJV FULL_NAME RAJV FULL_NAME1 RAJ.V SESSION_NAME s_m_CONTACTS_TGT CURRENT_DATE 4/26/2023 EMAIL_ID_LENGTH 13 LAST_DATE 4/30/2023 RAJV RAJ.V 10/27/2021 10/31/2021
salary+commisssion TARGET Target Filed Name Target Filed Datatype CONTACT_ID NUMBER
EMAIL VARCHAR2(255) PHONE VARCHAR2(20) CUSTOMER_ID NUMBER FULL_NAME VARCHAR2(255) FULL_NAME1 VARCHAR2(255) SESSION_NAME VARCHAR2(255) CURRENT_DATE DATE EMAIL_ID_LENGTH NUMBER LAST_DATE DATE
10 MINS
10/31/2021 Source File Name Source Filed Names Source Filed Datatype orders_src.csv ORDER_ID NUMBER(10) ORDER_DATE DATE STATUS VARCHAR2(255) QUANTITY NUMBER(10) PRICE DECIMAL(15,2) DISCOUNT NUMBER(10)
1 QUARTER 3 MONTHS 1 year= 4 QUARTERS 1 QUARTER JAN , FEB , MAR 2 QUARTER APR , MAY , JUNE 3 QUARTER JULY , AUG , SEP 4 QUARTER OCT, NOV ,DEC BUSINESS RULE Target File Name DIRECT MAPPING orders_target_ff.dat DIRECT MAPPING | - pipe DIRECT MAPPING DIRECT MAPPING DIRECT MAPPING DIRECT MAPPING CALCULATE QUANTITY*(PRICE -DISCOUNT) FOR FIRST QUARTER ONLY CALCULATE QUANTITY* (PRICE -DISCOUNT) FOR SECOND QUARTER ONLY CALCULATE QUANTITY* (PRICE -DISCOUNT) FOR THIRD QUARTER ONLY CALCULATE QUANTITY* (PRICE -DISCOUNT) FOR FOURTH QUARTER ONLY
ORDER_DATE=01-01-2022 MONTH
5 MINS
2/1/2022
11/21/2022 | ORDER_DATE MONTH=1 IF (MONTH=1 OR MONTH =2 OR MONTH=3 , CALCULATE QUANTITY*(PRICE -DISCOUNT) ,0) IF (MONTH=4 OR MONTH =5 OR MONTH=6 , CALCULATE QUANTITY*(PRICE -DISCOUNT) ,0) IF (MONTH=7 OR MONTH =8 OR MONTH=9 , CALCULATE QUANTITY*(PRICE -DISCOUNT) ,0) IF (MONTH=10 OR MONTH =11 OR MONTH=12, CALCULATE QUANTITY*(PRICE -DISCOUNT) ,0)
GET_DATE_PART(ORDER_DATE,'MM') DD MM YYYY
GET_DATE_PART(ORDER_DATE,'MM') QUANTITY* (PRICE- DISCOUNT) IIF(MONTH=1 OR MONTH=2 OR MONTH=3 , V_SALES ) order_date 11/17/2021 00:00:00
take the month out
month =11 Target Filed Name Target Filed Datatype ORDER_ID NUMBER(10) ORDER_DATE DATE STATUS VARCHAR2(255) QUANTITY NUMBER(10) PRICE DECIMAL(15,3) DISCOUNT NUMBER(10) Q1_SALES DECIMAL(15,3) Q2_SALES DECIMAL(15,3) Q3_SALES DECIMAL(15,3) Q4_SALES DECIMAL(15,3)
1 2 3 4
MM/DD/YYYY
Q1_SALES Q2_SALES Q3_SALES Q4_SALES KT -knowledge Transfer
5 people mapping documents 1- team lead 1- manager 2 - developers 1- ETL tester
oracle load data from source to target data Upstream source 20 tables
