KEMBAR78
File Processing System | PDF | Computers
Scribd
Upload
33 views8 pages

File Processing System

The document describes a file processing system that extracts, cleans, transforms, and loads data from various sources like email, FTP, and manual uploads. It processes file types like PDF, CSV, binary, and XML. The system outputs customized standalone data and consolidated reports, and has features to extract, clean, transform, and load data as efficiently as possible.

Uploaded by

RK Consultancy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
33 views8 pages

File Processing System

The document describes a file processing system that extracts, cleans, transforms, and loads data from various sources like email, FTP, and manual uploads. It processes file types like PDF, CSV, binary, and XML. The system outputs customized standalone data and consolidated reports, and has features to extract, clean, transform, and load data as efficiently as possible.

Uploaded by

RK Consultancy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 8

File Processing System

Extract Clean Transform Load


Types of Processing
Email Processing

Remote Data FTP, SFTP, SCP and Local Data

Manual Upload
Types of File
PDF
CSV
Binary
XLS
OCR
MQ, Web Services, LDAP
DBMS
XML
Output
Template based customized standalone data

Consolidated Report
Features
Extract
 Get the data from source system as efficiently as possible.
Clean
Perform data cleansing and dimension conforming.
Removes mistakes and corrects data.
Transform
Captures the flow of transactional data.
Perform calculations on data.
Adjusts data from multiple sources to be used together.
Load
Load the data in the target storage.
Key Features
Time saving
Performance
Load balancing
Massively Parallel Processing
Symmetric Multiprocessing
 Pipeline
 Multithreaded

User friendliness
Metadata Capture
GUI
Manageability
Security
Repository
Runtime
Scheduler Automation
Recovery and Restart
Workflow
Q&A

You might also like