•Describe the high level process flow and key activities involved, typical in an ETL data flow , Adeptia design tool can be used to create an empty flow without associating activities
•Identify specific activities for source schema and source type
•What type of sources e.g LAN, File System, FTP, Application (e.g. SalesForce), REST API
•Identify specific activities for Target Schema and target type
•What type of targets e.g LAN, File System, FTP, Application (e.g. SalesForce), REST API
•Identify mapping at field level from source schema to target schema. It is preferred to capture the mapping and mapping rules in an excel spreadsheet, Adeptia can provide a template for reference, Mapping rules, data validation, aggregation are the key points to be considered . Key considerations are one-one mapping or complex mapping involving more than on field to processed for the target field. Ensure that you have a good understanding of out of the box Mapping functions available.
•Any other pre-processing of source data and post-processing of data required, sometime pre-processing may be required like extracting from a zip file for source files, decryption, creating output a a zip file, encryption etc.
•Identify requirements if any for dynamic routing of data based on a rule within the data content or external criteria.
•Define exception handling and reporting exceptions and re-processing requirements for re-submission, process flow recovery, retention of processed files in the repository
•Identifying process flow triggers and events, design for easy migration across environments with parametrization of activity settings
•Design process flow for re-use, design process flows so that the process flows can be easily migrated to different environments without having to change activity parameters like FTP location, user id, password and other source and target activity parameters