Data Conversion
• Only convert essential data. Only convert objects that are essential to running the business.
• Pay careful attention to measurement data. Measurement data is very, very large and may take weeks to convert. Consider this: if it takes one hour to load measurements every day, how long will it take to load 5 years of measurements? Although conversion jobs are faster than regular data loading, measurement conversion still takes time. Here are a few measurement best practices:
◦ Projects are encouraged to only convert the minimum amount of measurement data required.
◦ If historical measurements are required, try to limit the amount of data converted. The best practice is to convert 13 months of consumption to support VEE.
◦ Only convert channels absolutely required, usually billing channels, and don’t convert other interval data if not needed.
◦ Measurement data values should be converted directly into the Measurement table and not use the IMD and VEE processes.
◦ Do not convert Initial Measurement (IMDs). Completed IMDs are not needed for any Meter Data Management processes.
◦ Remember that billing quantities will likely also be stored in the customer information system, so confirm that the measurement data is required before conversion.
Parent topic