In this project data is taken from text file sent by clinet everyday and SCD1 logic is implemented using Informatica and records are checked based MD5(message-digest algorithm) and the pipeline is scheduled on daily basis as a batch wise ingestion and the target is on the oracle db to the target warehouse