Friday 4 May 2012

INFORMATICA REALTIME UNIT TESTING

CASE 1: IF THE MAPPING DOES NOT CONTAIN ANY FILTER T/R OR LOOKUP T/R

STEP 1: TAKE THE SOURCE QUALIFIER QUARY FROM MAPPING AND RUN ON PERTICULAR DATABSE THEN CHECK HOW MENY RECORDS THE SOURCE QUALIFIER QUARY RETURNS.
STEP 2: RUN THE MAPPING AND CHECK THE TARGET COUNT IN WORKFLOW MONITOR STATISTICS.IF BOTH ARE SAME THEN NO ISSUE.

IF THE COUNT OF SOURCE AND TARGET COUNT ARE NOT MATCHING THEN THERE IS A PROBLEM IN MAPPING SO THAT CHECK THE MAPPING ONCE.

                                                           OR

SIMPLY RUN THE WORKFLOW AND CHECK THE STATISTICS OF SOURCE AND TARGET COUNT IN WORKFLOW MONITOR , IF BOTH(source,target) THE COUNT WILL MATCH THEN NO ISSUE.IF IT IS NOT MATCHING THERE IS A PROBLEM IN MAPPING SO CHECK THE MAPPING.

CASE 2: IF THE MAPPING CONTAIN FILTER T/R OR LOOKUP T/R

STEP 1:
             TAKE THE SOURCE QUALIFIER QUARY FROM MAPPING, ADD FILTER CONDITION TO SOURCE QUALIFIER QUARY,IF THE MAPPING CONTAIN LOOKUP T/R THEN ADD THAT LOGIC AS LEFT OUTER JOIN TO THE SOURCE QUALIFIER QUARY AND RUN THE QUARY ON PERTICULAR DATABSE THEN CHECK HOW MENY RECORDS THE SOURCE QUALIFIER QUARY RETURNS.


FOR EX:  SRC(EMP TABLE)-->SQ-->FIL(DEPT=10)-->EXP--->LKP(DEPT TABLE)-->TRG

ASSUME THAT IN LOOKUP CONDITION IS EMP.DEPTNO=DEPT.DEPTNO THEN RETURN DNAME.

FOR THAT MAPPING THE QUARY WILL BE  LIKE THIS::

SELECT EMPNO,ENAME,SAL,DEPTNO,DNAME
FROM EMP,DEPT
WHERE EMP.DEPTNO=10 AND
EMP.DEPTNO=DEPT.DEPTNO(+);

STEP 2:
            RUN THE MAPPING AND CHECK THE TARGET COUNT IN WORKFLOW MONITOR STATISTICS.IF BOTH(source and target count) ARE SAME THEN NO ISSUE.IF IT IS NOT MATCHING THEN CHECK THE BUSINESS LOGIC.

CASE 3:IF BOTH THE SOURCE COUNT TARGET COUNT MATCH THEN GO THROUGH WITH THE COLUMN MATCHING BASED ON THE LOGIC DEFINED IN THE MAPPING.IF IT IS FINE THEN NO ISSUE OTHER WISE FIND THE BUG AND FIX THAT BUG.

AFTER  FIX THE BUG AGAIN CHECK THE COLUMN ONCE AGAIN.