Low Level Design Template
This document compares Informatica PA versions for Dashboard & Chart functionality
DOCUMENT HISTORY
Date Revision Change
0.01D Created Initial Draft
26-Dec-05 1.0 Baselined
DOCUMENT CONTROL INFORMATION
Prepared By Kranti Modi
Maintained By BI CoE
All suggestions, comments, change requests and request for copies should be addressed to the BI-CoE Group.
Approved By BI CoE
Reference
Patni GE Public
o the BI-CoE Group.
Patni GE Public
Low Level Design
1. Data Warehouse Details
Customer Name
Application Name
Application Type
Domain Area
Application Usage
Application Platform
Database
Data quality Tools
ETL Tool
DWH Monitoring Tool
Scheduler
Front End
Middle Ware
Load Window
Data Window
Data Warehouse availability
2. Technical Details
Server Type Usage
Patni GE Public
3. Connectivity Details
Patni GE Public
Server Name IP Address Connectivity Location Domain
Patni GE Public
This metrix helps to analyze usage of dimensions
Subject Area
Dimension1 Dimension2 Dimension3
Fact1
Fact2
Fact3
Patni GE Public
Dimension4
Patni GE Public
List out all the sources used in ETL Process
Source Descriptio Platfor Data Method of Server Extractio Min
Application n m Storage extractio Name n Order Load
n
Patni GE Public
Max Avg Source Non-
Load Load Availability availability
handling
Patni GE Public
Prepare a separate sheet for individual subject area
Total Subject Areas
Total Target Tables
Total Target
columns
Total Business
Rules
Total
Transformation
Total DB Rules
Rules
Subject Area:
Target related Information Column Added Source related information
Sr. Target Table Name Target Column Data Null Source Table/ File
No Type Option
Patni GE Public
Added Source related information Column AddedTransformation
Column Added Rules
Source column Data Type Null Option Data Expression / Default Error/
Conversion Join value if Exception
Rule Condition in NULL Handling
case of
Lookup
Patni GE Public
Prepare a separate sheet for individual subject area
Total Subject Areas
Total Target Tables
Total Target
columns
Total Business
Rules
Total
Transformation
Rules
Total DB Rules
Subject Area:
Target related Information Column Added Source related in
Sr. Target Table Name Target Column Data Type Null Source Table/ File
No Option
Patni GE Public
Source related information Column Added Transformation
Column Added Rules
Source column Data Null Data Expression / Join Default
Type Option Conversi Condition in case of value if
on Rule Lookup NULL
Patni GE Public
on Rules
Error/ Exception
Handling
Patni GE Public
List all target tables and their load order for individual data warehouse/data mart
Sr.No Subject Area Target Table Name Table Type Load Load
Order Strategy
Patni GE Public
Column Added
Load Frequency Mandetory? Staging Restarta
Required? bility?
Patni GE Public
Worksheet has been added to give more details abt the session related properties
Mapping Source
Repository Folder Mapping Session Source Source Connection Table
name Name Name Name Type File name
Location
s_mapping
mapping_1 _1 DB2 NA UserID_Src1
s_mapping
REPDEV mapping_2 _2 Flat File Location ? NA
s_mapping
REPDEV mapping_3 _3 DB2 NA UserID_Src2
Patni GE Public
Source Target
Server Pre - SQL Post - Target Target Connection Table Table Server
Name SQL Type File name Properti Name
Location es
DB2 NA UserID_Stage
None None DB2 NA UserID_Stage
None None DB2 NA UserID_DWH
Patni GE Public
Pre-SQL Post - Post
SQL Pre Session Session Session
tasks Tasks Frequency
Patni GE Public
Worksheet has been added to provide summary of the generic details related to a session
Connection Details (Source/ Target):
Connection Name Host User ID Password
UserID_Src1
UserID_Src2
UserID_Scr3
UserID_Stage
UserID_DWH
Standard Notification Mechanism Email
Stage to Notify What to Notify User Group to Notify Email Tas
To (email - ids)
Session Failure Failure details Production support group
Workflow Completion Data Load completion Generic User ID
Server Folder Structure:
Mention the path where the following files are stored on the server:
Source Files \srcfiles
Target Files \tgtfiles
Parameter Files \prmfiles
Session Log Files \sesslogs
Session Bad Files \badfiles
Indicator Files \indfiles
Workflow Log Files \wkflogs
Patni GE Public
Connect String Default Remote
Directory
Email Task Details
Email Subject Email Body
Session Failure
Data Load Completion
Patni GE Public
Highlight the mechanism applicable for your project.
Standard Notification Mechanism E-Mail
Pager
Front-End Messages
Passive Mode - Database store
Stage to Notify What to Notify Mechanism to Notify User Group to Notify
Patni GE Public
Archive Notification messages?
Patni GE Public
