top_n_deposits

1.Description

This program takes cf files and ucic files generated by customer_master_gen to give six 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	currency_id	This gives the currency ID	USD
6	country_code	This gives the country code	US
7	base_ccy	Base currency	INR
8	connection_string	Connection to DB	Connection string should be in json format
9	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	""	Retail
4	option	Pipe-separated key-value pairs	""	key1,value1|key2,value2
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 six files:

1) pp_top_n_deposit.txt: This file data is loaded into TopNDepCust table.

2) pp_top_n_deposit_prod.txt: This file is not loaded to the DB.

3) top_n_dep_acc.txt: This file data is loaded into TopNDepCustAcc table.

4) top_n_dep_adv.txt: This file data is loaded into TopNDepCustAccAdv table.

5) top_n_int_rate.txt: This file is not loaded to the DB.

6) top_n_fcy.txt: This file data is loaded into TopNDepCustProd table.