Skip to content
/ Project_2_Loading_Customer_Details_Using_Informatica Public

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

0 stars 2 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

SubhashMurugesan/Project_2_Loading_Customer_Details_Using_Informatica

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
Datasets
Datasets
 
 
SCD_01_INFORMATICA
SCD_01_INFORMATICA
 
 
README.md
README.md
 
 

Repository files navigation

Project-2-Loading-Customer-Details-Using-Informatica

Source File Data Snip

Alt text

Informatica Logic Map

Alt text

Database View on Oracle db on the warehouse table

  • Oracle DB ,Warehouse table view after the first run with the exisiting soruce file

Alt text

Modified Dataset with new and update records

Alt text

Workflow run Status after the modified dataset

Alt text

Final Update on warehouse table on the Oracle DB

Alt text

Datasets Folder here

  • In this folder we can get the Initial Dataset

About

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

Topics

etl dataset informatica datawarehouse etl-pipeline scd01

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

2 forks
Report repository

Releases

No releases published

Packages

No packages published