code review

Reviews your ETL code automatically to help ensure that internal guidelines and best practices are observed. It assures that the development teams adheres to code quality, code maintainability, data quality and performance standards. It uncovers problems even before deployment to test environment and reduces cycle time.

code review profile

You are not yet signed into the system, please sign in and securely save your review results for your code quality analytics.

sign in sign up

Our services are running from free servers with limited resources. The server might run out of resources when running review with large review profiles. Please split your rule profiles into smaller rule profiles to overcome this resource crunch.

code review rule profile

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