ETL

iDecisions Consultants with their expertise in SQL and various ETL tools like Business Objects Data Integrator, Informatica & IBM Datastage, ensure the success of a Data Warehousing project.

Considering the ETL Best practices, procedures and tools, the iDecisions consultants:

• Work with various options like designer, mapping, workflow, scheduling etc.
• Work with sources like DBMS, relational source databases, files, ERPs etc.,
• Import the source definitions
• Import data from data modeling tools, applications etc.
• Work with targets like DBMS, relational source databases, files, ERPs etc.
• Create target definitions
• Create mappings between source definitions and target definitions
• Create the transformations
• Cleanse the source data
• Create a dimension, slowly changing dimensions, cube etc.
• Create and monitor workflows
• Configure, monitor and run debugger
• View and generate metadata reports