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

  1. Is the query reviewed by TECH lead/Data modeler?
  1. Is there any way to performance tune this query?
  1. 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