review dashboard

Capture metadata for each review for historic metrics to evaluate coding trends. Dashboard helps to pin point the area of improvement for individuals as well as for the whole team. Identify the potential training needs and help improve the overall teams performance and delivery quality.

You are not yet signed into the system, The analytics dashboard you see here is based on the demo data. Please sign in and securely save your review results and see your own analytics dashboard.

sign in sign up

team rule profile overview

team rule violations over 3 months

team top rule violations

Session property 'Stop On Error' should be set to 1
Every unconnected stored procedure transformation should be called from an ex...
Session property 'Enable high precision' should be enabled when decimal ports...
Aggregator Transformation should use 'Sorted Input' property
Command task property 'Fail task if any command fails' should be set to Yes
Back to back expression transformation should not be used in the mapping
Session property 'Tracing Level' should be set to Normal
Transformation port should be linked between ports with compatible datatype
All transformation input ports should have an incoming port linked

individual rule violations over 3 months

individual rule violations by criticality

code review results

go  
Review Results
Failed Rules 
Passed Rules 

code review rule profile

rule profile rule criticality rule category rule description
DI Code Maintainability Standards High Maintainability Sessions property 'Error Log Type' should be set to None
DI Code Maintainability Standards High Maintainability Session level parameter file value should be set to $PMExtProcDir
DI Code Maintainability Standards High Maintainability Workflow should be enabled
DI Code Maintainability Standards High Maintainability All sessions with in the workflow should be enabled
DI Code Maintainability Standards Low Maintainability Source table schema name should be parametrized
DI Code Maintainability Standards Low Maintainability Target table schema name should be parametrized
DI Code Maintainability Standards Low Maintainability Source and Target database connection names should be parametrized
DI Code Maintainability Standards Low Maintainability Post Session failure command should NOT be used in session
DI Code Maintainability Standards Low Maintainability Session property 'Write Backward Compatible Session Log File' should be set to Yes
DI Code Maintainability Standards Low Maintainability Workflow property 'Save Workflow log by' should be set to By timestamp
DI Code Maintainability Standards Medium Maintainability Source transformation instance should be shortcuts to shared objects
DI Code Maintainability Standards Medium Maintainability Target transformation instance should be shortcuts to shared objects
DI Code Maintainability Standards Medium Maintainability Session 'Log File directory' should be set to $PMSessionLogDir
DI Code Maintainability Standards Medium Maintainability Output file directory' should be set to $PMTargetFileDir
DI Code Maintainability Standards Medium Maintainability Source file directory' should be set to $PMSourceFileDir
DI Code Maintainability Standards Medium Maintainability Reject file directory' should be set to $PMBadFileDir
DI Code Maintainability Standards Medium Maintainability Pre Session command should NOT be used in session
DI Code Maintainability Standards Medium Maintainability Post Session success command should NOT be used in session
DI Code Maintainability Standards Medium Maintainability All tasks with in the workflow should be enabled
DI Code Maintainability Standards Medium Maintainability Workflow Log File Directory' should be set to $PMWorkflowLogDir
DI Code Maintainability Standards Medium Maintainability Session property 'Save session log for these runs' should be set to 10
DI Code Maintainability Standards Medium Maintainability Session property 'Save session log by' should set be set to Session timestamp
DI Code Maintainability Standards Medium Maintainability Worlflow property 'Write Backward Compatible Workflow Log File' should be set to Yes
DI Code Maintainability Standards Medium Maintainability Worlflow property 'Save workflow log for these runs' should be set to 10
DI Data Quality Standards High Data Quality All mappings should be valid
DI Data Quality Standards High Data Quality All transformation input ports should have an incoming port linked
DI Data Quality Standards High Data Quality All transformation output ports should have an outgoing port linked
DI Data Quality Standards High Data Quality All NOT NULL Target ports should have an incoming port linked
DI Data Quality Standards High Data Quality Transformation port should be linked between ports with compatible datatype
DI Data Quality Standards High Data Quality Transformation port should be linked between ports with compatible precision & scale
DI Data Quality Standards High Data Quality Every input transformation port should be used in a variable or output port
DI Data Quality Standards High Data Quality Session property 'Stop On Error' should be set to 1
DI Data Quality Standards High Data Quality All sessions with in the workflow should be valid
DI Data Quality Standards High Data Quality Sessions property 'Enable Test Load' should be disabled
DI Data Quality Standards High Data Quality Session property 'Enable high precision' should be enabled when decimal ports greater than precision 15 exist
DI Data Quality Standards High Data Quality Workflow task property 'Fail parent if this task fail' should be set to Yes
DI Data Quality Standards High Data Quality Workflow task property 'Fail parent if this task does not run' should be set to Yes
DI Data Quality Standards High Data Quality Command task property 'Fail task if any command fails' should be set to Yes
DI Data Quality Standards High Data Quality Workflow should be valid
DI Data Quality Standards High Data Quality All workflow task links should have a valid condition Yes
DI Data Quality Standards Medium Data Quality Aggregator Transformation should have at least one 'GroupBy' port
DI Data Quality Standards Medium Data Quality Rank Transformation should have at least one 'GroupBy' port
DI Data Quality Standards Medium Data Quality Every variable transformation port should be used in a variable or output port
DI Data Quality Standards Medium Data Quality Every unconnected lookup transformation should be called from an expression transformation
DI Data Quality Standards Medium Data Quality Every unconnected stored procedure transformation should be called from an expression transformation
DI Data Quality Standards Medium Data Quality Sessions property 'On Stored Procedure error' should be set to Stop
DI Data Quality Standards Medium Data Quality Sessions property 'On Pre-Session command task error' should be set to Stop
DI Data Quality Standards Medium Data Quality Sessions property 'On Pre-Post SQL error' should be set to Stop
DI Data Quality Standards Medium Data Quality Source file code page' setting should be set to UTF-8
DI Data Quality Standards Medium Data Quality Target file code page' setting should be set to UTF-8
DI Data Quality Standards Medium Data Quality Workflow task property 'Treat the input links as' should be set to AND
DI Performance Standards High Performance Aggregator Transformation should use 'Sorted Input' property
DI Performance Standards High Performance Joiner Transformation should use 'Sorted Input' property
DI Performance Standards High Performance Transformation property 'Tracing Level' should be set to Normal
DI Performance Standards High Performance Back to back expression transformation should not be used in the mapping
DI Performance Standards High Performance Back to back Aggregator transformation should not be used in the mapping
DI Performance Standards High Performance Back to back Filter transformation should not be used in the mapping
DI Performance Standards High Performance Back to back Router transformation should not be used in the mapping
DI Performance Standards High Performance Session property 'Tracing Level' should be set to Normal
DI Performance Standards High Performance Sessions property 'Additional Concurrent Pipelines for Lookup Cache Creation' should be set to Auto
DI Performance Standards High Performance Sessions property 'Pre-build lookup cache' should be set to Auto
DI Performance Standards Low Performance Back to back Transaction Control transformation should not be used in the mapping
DI Performance Standards Low Performance Router Transformation should use a non default 'TRUE' group condition
DI Performance Standards Medium Performance Router Transformation should have more than one output group
DI Performance Standards Medium Performance Union Transformation should have more than one input group
DI Performance Standards Medium Performance Back to back Sorter transformation should not be used in the mapping
DI Performance Standards Medium Performance Back to back Update Strategy transformation should not be used in the mapping
DI Performance Standards Medium Performance Back to back Rank transformation should not be used in the mapping
DI Performance Standards Medium Performance Back to back Union transformation should not be used in the mapping
DI Performance Standards Medium Performance Filter transformation should use a non default 'TRUE' filter condition
DI Performance Standards Medium Performance Sessions property 'Commit Interval' should be set to 10000
DI Performance Standards Medium Performance Sessions property 'Session retry on deadlock' should be set to YES
DI Readability Standards Low Readability Expression transformation name should start with exp_
DI Readability Standards Low Readability Update Strategy transformation name should start with upd_
DI Readability Standards Low Readability Rank transformation name should start with rnk_
DI Readability Standards Low Readability Filter transformation name should start with fil_
DI Readability Standards Low Readability Router transformation name should start with rtr_
DI Readability Standards Low Readability Aggregator transformation name should start with agg_
DI Readability Standards Low Readability Source Qualifier transformation name should start with sq_
DI Readability Standards Low Readability Sorter transformation name should start with srt_
DI Readability Standards Low Readability Union transformation name should start with uni_
DI Readability Standards Low Readability Stored Procedure transformation name should start with sp_
DI Readability Standards Low Readability Transaction Control transformation name should start with tc_
DI Readability Standards Low Readability Joiner transformation name should start with jnr_
DI Readability Standards Low Readability Sequence transformation name should start with seq_
DI Readability Standards Low Readability SQL transformation name should start with sql_
DI Readability Standards Low Readability Session Merge filename should follow the name pattern contains Target Name
DI Readability Standards Low Readability eMail Task transformation name should start with eml_
DI Readability Standards Low Readability Start Task transformation name should start with Start
DI Readability Standards Low Readability Control Task transformation name should start with ctrl_
DI Readability Standards Low Readability Command Task transformation name should start with cmd_
DI Readability Standards Low Readability Decision Task transformation name should start with dec_
DI Readability Standards Low Readability Event Wait Task transformation name should start with evtw_
DI Readability Standards Low Readability Event Raise Task transformation name should start with evtr_
DI Readability Standards Low Readability Timer Task transformation name should start with tim_
DI Readability Standards Low Readability Assignment Task transformation name should start with assn_
DI Readability Standards Low Readability Worklet Task transformation name should start with wrklt_
DI Readability Standards Low Readability Workflow name should follow the name pattern contains Session Name
DI Readability Standards Low Readability Workflow Log Filename should follow the name pattern contains Workflow Name
DI Readability Standards Low Readability Mapping name should follow the name pattern contains Target Name
DI Readability Standards Low Readability Every mapping transformation should have a description
DI Readability Standards Low Readability All Target ports should be linked from an Expression transformation
DI Readability Standards Low Readability All Source Qualifier ports should be linked to an Expression transformation
DI Readability Standards Low Readability Multiple DML operations (INSERT, UPDATE, DELETE) should NOT be done on single Target instance
DI Readability Standards Low Readability Every session should have a session description
DI Readability Standards Low Readability Every workflow task should have a description
DI Readability Standards Medium Maintainability None of the sessions should use session level source SQL override
DI Readability Standards Medium Maintainability None of the sessions should use session level LookUp SQL override
DI Readability Standards Medium Readability Mapping name should follow the name pattern starts with m_
DI Readability Standards Medium Readability Session name should follow the name pattern starts with s_
DI Readability Standards Medium Readability Session Log Filename should follow the name pattern contains Session Name
DI Readability Standards Medium Readability Session Output Filename should follow the name pattern contains Session Name
DI Readability Standards Medium Readability Session Reject filename should follow the name pattern contains Target Name
DI Readability Standards Medium Readability Mapping name should follow the name pattern contains Schema Name
DI Readability Standards Medium Readability Session name should follow the name pattern contains Mapping Name
DI Readability Standards Medium Readability Every mapping should have a mapping description
DI Readability Standards Medium Readability Every complex transformation port expression should have a description
DI Readability Standards Medium Readability Every workflow should have a description