Yes, let me have it!
Fill out the form below to access this resource. All fields are required.
Top Tips for Data Integrator
The BI Builders recommend Data Integrator as a great addition to any BI or ad-hoc reporting environment. With ETL, universes, and meta-data, reporting users can get the answers they need with less work and can trust the results, with one version of the truth. Here are some tips for effective Data Integrator development:
1. Define a naming convention to group related tasks.
2. Create a \\\'script\\\' for the job flow; always create dimension tables and fact tables first.
3. Thoroughly test data quality. Never assume data is clean.
4. Create individual tasks in each Data Flow and use Work Flow to group them.
5. Define and create job log files during the job execution to track job statuses, terminations, errors, etc.
6. Document as much as possible.
7. Whenever possible, reuse ETL logic and components by defining variables.
Download now. Or if you would like to speak to someone about Data Integrator development, please fill in the form on the right.
