Livoa LogoLivoa
BDC Input File


(one-time)

CIQ Server


DB: BDC

Table: BDCInputMaster

Generation of LXIDs


Loaded for the entire rows of data WHERE LXID is NULL

Creation/Updation of Borrower IDs


Loaded for distinct Borrowers WHERE BorrowerID is NULL

Creation/Updation of BDC IDs


Loaded for distinct BDCs WHERE BDC_ID is NULL

* Creation/Updation of BDCID: Still in discussion phase

BDC Input File


(Delta & Incremental)

File carrying the addition/updates will be plugged into the BDCMaster table with the new data which will reside with the historical data.
New 10K/10Q/10KA/10Q/A comes every quarter
Extraction happens as per design (Still being explored)
Json file is created carrying the extracted data
LOAD
PF JOBS
KPS:
KPS:
KPS:
Update BorrowerID
Update LX ID
Update BDC_ID
PUSH
1
2
4
5

chaatey

by fareed

0
0 uses