top_n_borrowers

1.Description

This program takes cf files and ucic_master2.txt generated by customer_master_gen to give two different top_n files.

2.1 Process Config Fields

2.1.1 Additional Input file

This file contains:

#	File	Type	Description	Required
1	Output Metadata files	Output Metadata	Provide the path to the output metadata files of SA,CA,TD and RD.	true
2	UCIC	Reference	Output of customer_master_gen	true
3	Exchange Rate	ExchangeRate	Exchange_rate file	true

2.2 Process Arguments

Here enter the process arguments to be passed to the program. The mandatory and non-mandatory fields are given below.

2.2.1 Mandatory Parameters

#	Parameters	Description	Example
1	process_config	Path to process config file that needs to be processed	/path/to/process_config.json
2	as_on_date	The date for which the program has to run	2024-11-28
3	log_file_path	Path to write logs	test-bed/log.txt
4	diagnostics_file_path	Path to write diagnostics logs	test-bed/diag_log.txt
5	country_cd	This gives the country code	US
6	base_ccy	Base currency	INR
7	connection_string	Connection String JSON Data	Connection string should be in json format
8	top_cust_count	Number of top customers	10

2.2.2 Non-Mandatory Parameters

#	Parameters	Description	Default Value	Example
1	log_level	Level of diagnostics written to the log file	info	debug
2	is_perf_diagnostics_enabled	Flag to enable performance diagnostics	false	true
3	prod_type	Product type (optional)	""	Retail
4	option	Pipe-separated key-value pairs	""	key1,value1
5	is_consolidated	Flag to indicate if currency is consolidated	false	true

2.3 Derivations

3. Output and data loading to DB

This program generates a total of two files:

1) top_n_borr.txt: This file data is loaded into TopNAdvCust table.

2) top_n_borr_adv.txt: This file data is loaded into TopNAdvCustAcc table.