Exercise Info
- Application (Classic vs Data Prep Studio): Classic & Data Prep Studio
- Level of Difficulty (Beginner, Intermediate, Advanced): Advanced
- Skills/Features Tested: Floating Trap, Multi-Column Region (MCR), Top 10, Analyze
- Systems of Record: DXC Hogan
- Estimated Time to Solve: 15 mins
- Exercise files required are attached Below;
- Hogan DR0042 - Daily Deposit System Transctions Extract.txt
- Checking Accounts.csv (Zipped)
- Debit Card Masterfile.csv (Zipped)
- Customer-Membership Demographics.csv (Zipped)
Exercise Overview
You are a Debit Card Operations Analyst at a Financial Institution and your Manager has asked you to identify the Top 10 Customers based on Debit Card Purchasing Activity (Tran Code = 1238), from the DR0042 - Daily Deposit System report in your Hogan Core Banking Mainframe.
To accomplish this you need to do the following:
Steps
- Classic: Create a Classic Model to extract the data from the DR0042 Report
- Hint: Requires a Floating Trap & the Multi-Column Region
- Data Prep Studio: Import the Classic Model and the Report into Data Prep Studio to combine the data
- Hint: You need to use the csv files to combine fields and identify customers
Answer
- Please upload your answers below in the comment section for the exercise
- A Video Answer to the question will be published within 7-10 days on the Monarch Succcess Plan page in the 'Monarch Exercises' section.
