Opening book details…
Can I read Transaction Data Transformation Guide on EtoBox?
Transaction Data Transformation Guide by durgavihashini.p26 is a document available to read on EtoBox.
What is Transaction Data Transformation Guide about?
The document outlines data transformation tasks involving three tables: transactions, bank_products, and customer_dimension. It specifies creating a pivoted table for total debited and credited amounts by customer and updating the active_flag in the customer_dimension table based on specific conditions. Additionally, it mentions implementing an incremental load logic for transferring data from the transaction table in the transaction_bronze database to the transaction_silver database.
- Author
- durgavihashini.p26
- Language
- EN