Optimize ETL For Banking DDS : Data Refinement Using ETL Process For Banking Detail Data Store(DDS)

— Our project deals with unstructured and raw data and converts it to structured and consistent data by applying modern data warehousing, business intelligence concept and ETL tool Informatica. Throughout the project we are in continues communication with clients and get updated files for correction these modern tool we help us for generating audit reports. We classify data quality problems that are addressed by data cleaning and provide an overview of the main solution approaches. Data cleaning is especially required when integrating heterogeneous data sources and should be addressed together with schema-related data transformations. In data warehouses, data cleaning is a major part of the so-called ETL process. We also discuss current tool support for data cleaning.