Vijay works in an IT company for last 5 years, he always needs extra money to spend on his monthly expenses so he decided to apply for the credit card in icici bank. The bank does a background check of vijay to know if he is elligible for the credit card or not.
The ICICI bank want to use the customer data to check the eligibility of getting a credit card. The bank will monitor all the parameters such as the Employee history of the customer which are the previous companies he worked for , what is his current salary, what is his designation, how frequently he changes the job and the credit score hostory of the customer, All the data related to the customer is available in the the MS SQL Server database now the bank hires a ETL developer and wants the data to be loaded in the oracle database and to know the designation and credit score history. The ETL developer decided to use Informatica for the above problem and used SCD 2 implementation.
