|
Determine Special Processing Requirements |
Scroll |
1.Identify any source data filtering that needs to be performed. Filtering may require the use of the CASE/WHEN or the IF and/or WHERE functions.
2.Identify any external datastores that need to be referenced in order to map certain target fields. These external datastores may require a Cursor operation.
3.Identify any special date formatting that needs to be performed.
4.Determine if any of the source data needs to be normalized into one (1) or more target datastores. This may require the use of the NORM function.
5.Determine the commit frequency, if any, required for processing source/target data. If a commit frequency is desired, you will need to use the COMMIT command in environment section.
6.Determine if any special Initialization processing is required before the Main
