Efforts to improve the performance of services on the transaction at a bank can be done by performing data retention, reduce the volume of data in the database production by cutting the historical data in accordance with the rules in a bank to a data warehouse. Design and implementation of applications Domain Specific Language (DSL) for handling the data transfer on the data warehouse is divided into lexical analysis, syntax analysis, semantic analysis and code generation. Each part has different characteristics to produce an executable command. Has been developed an application with the DSL method, which is beneficial to reduce the error of writing a command for a normal (non-technical) way to transfer data. From the test result in a decision Oracle transfer method according to the size scale of a particular data.