Scribd Logo
Upload

Welcome to Scribd!

  • 962 views

    Informatica Codereview Checklist

    Uploaded by

    Aravind Pandey
    This document summarizes an Informatica code review that was performed by a developer and reviewer on a specific date. It includes checklists to ensure naming conventions, parameters, logging, sessions, mappings and other objects were configured correctly according to standards. The reviewer signs off that all items were validated and the implementation is ready to move to the application folder.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd

    Informatica Codereview Checklist

    Uploaded by

    Aravind Pandey
    962 views4 pages
    This document summarizes an Informatica code review that was performed by a developer and reviewer on a specific date. It includes checklists to ensure naming conventions, parameters, logging, sessions, mappings and other objects were configured correctly according to standards. The reviewer signs off that all items were validated and the implementation is ready to move to the application folder.

    Original Description:

    Informatica Codereview Checklist.xls

    Original Title

    Informatica Codereview Checklist.xls

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document summarizes an Informatica code review that was performed by a developer and reviewer on a specific date. It includes checklists to ensure naming conventions, parameters, logging, sessions, mappings and other objects were configured correctly according to standards. The reviewer signs off that all items were validated and the implementation is ready to move to the application folder.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    962 views4 pages

    Informatica Codereview Checklist

    Uploaded by

    Aravind Pandey
    This document summarizes an Informatica code review that was performed by a developer and reviewer on a specific date. It includes checklists to ensure naming conventions, parameters, logging, sessions, mappings and other objects were configured correctly according to standards. The reviewer signs off that all items were validated and the implementation is ready to move to the application folder.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 4

    Informatica Code Review Objects Reviewed

    Reference Doc Developer Reviewer Date Area Covered

    Informatica Naming Convention v1.0 <Name Of Developer> <Name Of Reviewer> <Date> # CheckList Workflow Name confirms to standard document. 1 Comments for workflow is meaningful. 2 Parameter File with location is mentioned correctly. 3 Workflow logfile name is mentioned correctly. 4 Workflow logfile is created in designated UNIX folder. 5 Save Workflow Logs Run by is "By Runs". 6 Last 5 logs are saved. 7 LogFile Tracing is "Normal". 8 Variables are defined correctly (if applicable) 9 10 11 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 All sessions / tasks / worklets are valid in the workflow and checked in. No change in session attributes done at workflow level. Session Name(s) confirms to standard document. Description for session(s) is/are meaningful. Session is mapped to correct mapping. Parameter File name with location is mentioned correctly. Checkbox for "Fail Parent if this task fails" is checked. Session logfile name is mentioned correctly. $Source and $Target value is set correctly. Commit Interval is set to 2147483647. Checkbox for "Commit on End Of File" is checked. Attribute "Treat Source Rows as" is selected correctly. Save Session Logs Run by is "Session Runs". Last 5 logs are saved. Stop on Errors value is set as '1' LogFile Tracing is "Normal". Connections are defined correctly for Source, Target, Lookups, SQL Transformations Input File Directory is mentioned correctly (if applicable). Input Filename confirms to IC document (if applicable). Output File Directory is mentioned correctly (if applicable).

    TCS-Humana Internal

    Session

    Workflow

    Ses

    19 20 21 22 23 24 25 26 1 2 3 4 5 6 7

    Output Filename is mentioned correctly (if applicable). Reject File Directory is mentioned correctly (if applicable). Reject Filename is mentioned correctly (if applicable). Target Load in case of Table is selected as Bulk unless otherwise required for the process. Stage Tables are truncated before use. Load Types are checked correctly based on requirements. Pre/Post Commands are defined correctly (if applicable). Session(s) is/are valid and checked in. Mapping Name(s) confirms to standard document. Description for Mapping(s) is/are meaningful. Description for all objects in mapping is meaningful. SQ / LKP transformation has correct SQL overide (if applicable). SQL Override is formated correctly. Ports - No Hanging ports in any of the transformation (except where it is not possible). Port Names confirmed to standard document. Datatypes and Length are correctly matched through Source to Target. If aggregartor need to be done on big volumn to data, sorter is used before that to improve the performance.If you use sorter please check sorted input check box in Aggregator. For Partitions / Date bounderies, Parameters are used correctly in the mapping. Mapping(s) is/are valid and checked in. Parameter File got correct/required values for Session(s). Database Connection is using correct parameter file. Database connection is pointing to right schema/database. LogFiles are getting created in correct folder. Objects are Ready to Move to Application Folder.

    Mapping

    8 9 10 1 2 3 4 5

    TCS-Humana Internal

    Others

    ca Code Review

    Note: Valid Values for Implementation. Y - Yes / N - No / NA - Not Applicable. Closed - Y - Yes / N - No / NA - Not Applicable. Implementation(Y/N) Developer Reviewer Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Comments Closed (Y/N)

    TCS-Humana Internal

    Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y

    Y Y Y Y Y Y Y Y

    TCS-Humana Internal

    You might also like