Unit of competency Outline

Date retreived
22/07/2026 8:32 AM AWST

Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.

Complete data transition in data migration process

Complete data transition in data migration process

Unit of competency
National Code
ICTSAS408
State Code
AUW29
TGA Status
Deleted
DTWD Status
Transition (Deleted)
Current Release Number
1.00
Current Release Date
25/03/2015
View on TGA
State Implementation and Classification
Approved Date
16/09/2015
Field of Education
020303 - Database Management
Original Release Date
16/09/2015
Nominal Hours
25
Description
This unit describes the skills and knowledge required to undertake manipulation, migration and conversion of data between systems or databases while maintaining data integrity.It applies to individuals who use technical and specialised knowledge, and apply a systematic approach to perform operations relating to the implementation of new systems.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Perform data transition
  • 1.1 Identify and document data that is to be migrated, transferred or archived
  • 1.2 Collect required data, target database requirements and implementation details
  • 1.3 Clean up data to match new data structures and rules
  • 1.4 Write and test conversion programs if required by the implementation plan, or use conversion tools
  • 1.5 Ensure clean data take-on by re-keying or converting according to database requirements and conversion plan
  • 1.6 Migrate data to target environment
  • 1.7 Archive data according to requirements
2. Check data transition
  • 2.1 Run reports and other tests on old and new data to verify the quantity and quality of data transition
  • 2.2 Run production or specialised programs against data to confirm control totals
  • 2.3 Check referential integrity and data constraints and requirements against database requirements and conversion plan
  • 2.4 Verify that data transition has been completed according to requirements and plans
No information
No information
Replaces
State Code National Code Title Type
D8070 ICASAS408A Complete data transition in data migration process Unit of competency
State Code National Code Title Type
BEH4 ICT40118 Certificate IV in Information Technology Qualification
AWB5 ICT40115 Certificate IV in Information Technology Qualification