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 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 Transformation property 'Tracing Level' should be set to None
DI Public Profile Back to back expression transformation should not be used in the mapping
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 Public Profile Sessions property 'Error Log Type' should be set to Relational Database
DI Public Profile Source table schema name should be parametrized
DI Public Profile Target table schema name should be parametrized
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
DI Public Profile
DI Public Profile
DI Public Profile
DI Public Profile
DI Public Profile
DI Public Profile
DI Public Profile
DI Public Profile
DI Public Profile Every mapping transformation should have a description
DI Public Profile All Target ports should be linked from an Expression transformation
DI Public Profile All Source Qualifier ports should be linked to an Expression transformation
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 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 input 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 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 Aggregator Transformation should have at least one 'GroupBy' port
Data Change Rank Transformation should have at least one 'GroupBy' port
Data Change All mappings should be valid
Data Change All transformation input ports should have an incoming port linked
Data Change All transformation output ports should have an outgoing port linked
Data Change All NOT NULL Target ports should have an incoming port linked
Data Change Transformation port should be linked between ports with compatible datatype
Data Change Transformation port should be linked between ports with compatible precision & scale
Data Change Every variable transformation port should be used in a variable or output port
Data Change Every input transformation port should be used in a variable or output port
Data Change Every unconnected lookup transformation should be called from an expression transformation
Data Change Every unconnected stored procedure transformation should be called from an expression transformation
Data Change Aggregator Transformation should use 'Sorted Input' property
Data Change Joiner Transformation should use 'Sorted Input' property
Data Change Router Transformation should have more than one output group
Data Change Union Transformation should have more than one input group
Data Change Back to back expression transformation should not be used in the mapping
Data Change Back to back Sorter transformation should not be used in the mapping
Data Change Back to back Update Strategy transformation should not be used in the mapping
Data Change Back to back Aggregator transformation should not be used in the mapping
Data Change Back to back Filter transformation should not be used in the mapping
Data Change Back to back Router transformation should not be used in the mapping
Data Change Back to back Transaction Control transformation should not be used in the mapping
Data Change Back to back Rank transformation should not be used in the mapping
Data Change Back to back Union transformation should not be used in the mapping
Data Change Filter transformation should use a non default 'TRUE' filter condition
Data Change Router Transformation should use a non default 'TRUE' group condition
Data Change Sessions property 'Error Log Type' should be set to Relational Database
Data Change Session 'Log File directory' should be set to log
Data Change Output file directory' should be set to directory
Data Change Source file directory' should be set to file
Data Change Reject file directory' should be set to files
Data Change Source table schema name should be parametrized
Data Change Target table schema name should be parametrized
Data Change Source and Target database connection names should be parametrized
Data Change Pre Session command should NOT be used in session
Data Change Post Session success command should NOT be used in session
Data Change Post Session failure command should NOT be used in session
Data Change Session level parameter file value should be set to level
Data Change Expression transformation name should start with E
Data Change Update Strategy transformation name should start with UP
Data Change Rank transformation name should start with RA
Data Change Filter transformation name should start with F
Data Change Router transformation name should start with RO
Data Change Aggregator transformation name should start with A
Data Change Source Qualifier transformation name should start with SOU
Data Change Sorter transformation name should start with SOR
Data Change Union transformation name should start with UN
Data Change Stored Procedure transformation name should start with ST
Data Change Transaction Control transformation name should start with TR
Data Change Joiner transformation name should start with JO
Data Change Sequence transformation name should start with SE
Data Change SQL transformation name should start with SQL
Data Change Mapping name should follow the name pattern starts with m_
Data Change None of the sessions should use session level source SQL override
Data Change None of the sessions should use session level LookUp SQL override
Data Change Session name should follow the name pattern starts with Mapping Name
Data Change Session Log Filename should follow the name pattern starts with Session Name
Data Change Session Output Filename should follow the name pattern starts with Target Name
Data Change Session Reject filename should follow the name pattern starts with Session Name
Data Change Session Merge filename should follow the name pattern starts with Target Name
Data Change eMail Task transformation name should start with T
Data Change Start Task transformation name should start with TA
Data Change Control Task transformation name should start with CT
Data Change Command Task transformation name should start with CTT
Data Change Decision Task transformation name should start with DT
Data Change Event Wait Task transformation name should start with EWT
Data Change Event Raise Task transformation name should start with ERT
Data Change Timer Task transformation name should start with TRT
Data Change Assignment Task transformation name should start with AT
Data Change Worklet Task transformation name should start with WO
Data Change Workflow name should follow the name pattern starts with wf_
Data Change Workflow Log Filename should follow the name pattern starts with wf_
Data Change Session property 'Save session log for these runs' should be set to runs
Data Change Session property 'Save session log by' should set be set to Session runs
Data Change Session property 'Write Backward Compatible Session Log File' should be set to Yes
Data Change Worlflow property 'Write Backward Compatible Workflow Log File' should be set to Yes
Data Change Worlflow property 'Save workflow log for these runs' should be set to example
Data Change Workflow property 'Save Workflow log by' should be set to By runs
Data Change Session property 'Stop On Error' should be set to error
Data Change Sessions property 'On Stored Procedure error' should be set to Continue
Data Change Sessions property 'On Pre-Session command task error' should be set to Continue
Data Change Sessions property 'On Pre-Post SQL error' should be set to Continue
Data Change All sessions with in the workflow should be valid
Data Change Source file code page' setting should be set to ASCII
Data Change Target file code page' setting should be set to UTF-8
Data Change Sessions property 'Enable Test Load' should be disabled
Data Change Session property 'Enable high precision' should be enabled when decimal ports greater than precision 15 exist
Data Change Session property 'Tracing Level' should be set to Normal
Data Change Sessions property 'Additional Concurrent Pipelines for Lookup Cache Creation' should be set to Lookup
Data Change Sessions property 'Pre-build lookup cache' should be set to Auto
Data Change Sessions property 'Commit Interval' should be set to interval
Data Change Sessions property 'Session retry on deadlock' should be set to YES
Data Change All tasks with in the workflow should be enabled
Data Change Workflow should be enabled
Data Change All sessions with in the workflow should be enabled
Data Change Workflow Log File Directory' should be set to CSAP
Data Change Every session should have a session description
Data Change Every workflow should have a description
Data Change Every workflow task should have a description
Data Change Workflow task property 'Fail parent if this task fail' should be set to Yes
Data Change Workflow task property 'Fail parent if this task does not run' should be set to Yes
Data Change Workflow task property 'Treat the input links as' should be set to AND
Data Change Command task property 'Fail task if any command fails' should be set to Yes
Data Change Workflow should be valid
Data Change All workflow task links should have a valid condition Yes
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
Data Change Transformation property 'Tracing Level' should be set to Normal