1.E BanK, Unified Data Processing in ETL & Batch

Customer Requirements

  • A next-generation conversion of M/F and IMS HDB
  • Interactive ETL process
  • High volume data handling within batch process time

Results

  • Converting main frame data into Unix data (1TB → 1.5TB) including Korean character conversion.
  • ETL task from accounting system server to new ODW server(extracting appx. 200 GB of daily changed data within 1 hour and 30 minutes by using FACT™ of TeraStream™)
  • Data hub is used in ETL process from new core banking system to subjective marts. (EUC, KPI, RISK, IFRS, Basel2)
  • ETL and Batch process in unified way.
  • Batch process is designed to be done in both ODW and EDW.

Expected Result

  • TeraStream™ is in charge of data flow from core-banking to data mart.
  • Batch job is also executed during ETL process in the same manner.
2.K Bank, EDW and integrated DM installation

Customer Requirements

  • M/F and IMS HDB conversion Processing changed data in absence of time-series column
  • Processing large size data within batch process time(10TB/day based on source data)
  • How to process high volume files in parallel

Results

  • Converting main frame data into data in Unix environment (10TB → 25TB) within 18 hours.
  • Various data conversion and processing including Korean character conversion
  • ETL task from accounting system server to new ODW server(extracting appx. 200 GB of daily changed data within 1 hour and 30 minutes by using FACT module of TeraStream™)
  • ETL and Batch process in unified way.
  • Batch job in core banking system within 6 hours.

Expected Result

  • Various DBMS(IMS HDB, HOST DB2, Oracle, DB2 UDB) integration by using TeraStream™
  • Meeting batch target time of 2 hours and 30 minutes for 4TB of EBCDIC data.