For clients we are giving DWE extract which is extracted raw data from DB tables. When we are doing upgrade, Columns changes, new columns get added which cause problem for bank to consume extract. To solve this problem we have build one automated solution which will compare and give output between two versions.
This tool compares the different DDL versions and generates report on the differences. For Example: If the end user feeds in the two different DDL files, the tool will process with the input files and output a report with the differences like, new column, renamed column, delete column, data type changed, etc.
As of now this solution is only for LoanIQ DWE but going forward this can be implemented for all other product which has ETL extract.
Built With
- 3.-antlr
- java
- spring-boot
