Gap Analysis

Posted on 2021-01-16 09:31:52 by admin

Data gap analysis is the process of analyzing the data structures of source system & target datawarehouse. It is first step for a wide variety of data integration tasks including: data transformation or data mediation.

Different source system can provide multiple different data formats (flatfile, xml, IDOC, csv, excel, delimited, system specific etc) to be consumed by datawarehouse application. Our experts define all such requirements, formats, mappings & various complex transformations that require one-to-many and many-to-one transformation rules.

ETL programs may need to connect to different source systems (like SAP, Oracle, AS400 etc) to pull data from file system or operational stores. Our experts will identify, configure & deploy the adapters required to connect to the source system and ensure smooth connectivity enabling system integration & data flow.

The Extract,-Transform-Load (ETL) software (e.g. Informatica, Cognos Data Manager etc) processes inconsistent data, cleanses "bad" data, filters data and loads data from source to staging to target database. Three phases are scheduled & executed in parallel using the scheduling tools like Opalis, Tidal etc.