KYC low level design
Query Analysis
Query runs in under 5 minutes
Quey join multiple views in CDS
Query Does NOT join the new CPC table
Need to predict the performance after joining CPC table
click to edit
Process Setup
Database Details
Which Database - CDS✅
Which Schema for Tables⚠
Does Data Modelling know this information?
Which Schema for Procedures❌
Which schema will be used for execution
Pre-processing
Which process group
How do we plan to create process ids How many?
How do we plan to TRACK each step for troublesho
- Is the query reviewed by TECH lead/Data modeler?
- Is there any way to performance tune this query?
- Do we plan to Store query pull into TEMP Table?
3.1TRUNCATE table before daily load
3.2Load the data from query
3.3Create required indexes
3.3.1 Which columns need to be indexed?
3.4Analyze table
3.5 Merge temp data into KYC_NTFCN table
3.5.1 Insert KYC_NTFCN if the PARTY don't exists
3.5.2 Update KYC NTFCN for existing PARTY_ID
3.5.3 Analyze the KYC NTFCN table