Is ecif system based on several warehouses?

yes.

The warehouse architecture is divided into five layers. The first layer is the data source, also known as the upstream system. Taking the bank as an example, the data source consists of the core system, ECIF, loan system, deposit system, intermediate business general ledger system and financial system. The second layer, the paste source layer, also known as the standardization layer (ODS), requires cleaning dirty data (using regular expressions and conditional filtering), standardizing naming, standardizing data types and formats, and adding timestamp fields. The source layer is extracted synchronously with ETL tools (datastage, kettle, infomatica). Asynchronous transmission with shell script. The third layer, FDM layer (basic layer), summarizes processing source data (ods layer data) according to business conditions (or business logic) to form a wide table. The fourth layer (realized by stored procedures), summary layer/topic layer. Summarize by different dimensions (institution, date, currency and location); Refine subject data according to customer requirements (where filtering). (realized by stored procedures) The fifth layer, the application layer. Including reports, downstream systems, data platforms and data marts.