FW: files

Controls:
========
1) Adequate set of controls for loading data from Financials to EPM
- At all levels
- Automation
- Quality
- Integrity
- What processes
balances/row counts
- Error handling - sending emails
- Creating schedule (sequential, parallel) - Atleast once a day with flexibility to run adhoc

2) Current Status of Stress testing
- Driving refresh rate
- How long does it take to refresh the data

3) EPM scenarios
- What are the complete scenarios

High level plan
===============
1) I have not seen it

Dependecies
============
3 and 3b and 6 can run in parallel
4 and 5 are dependent on 3
5 is dependent on 4

Hash file location/what to look for in the hash file
balance/row counts and table names by job grouping
Error handling - Dsjob exit status/row counts/balances

Donot run AP&GL
===============
Use Batch00
XLEBICCC
BBBATCH
VNDCNV

 

 

-----Original Message-----
From: Yadlapati Srikanth
Sent: Tuesday, December 11, 2007 11:27 AM
To: Vanamamalai Murali
Subject: FW: files

 

Hash file location

The hash file is located in the directory:

 

/apps/Ascential/DataStage/Projects/<db name>/SDKMaxLastUpdDttm_E

 

In order to read it we must use the dssh executable.  The command looks like this:

$DSHOME/bin/dssh "SELECT MaxDateTime from SDKMaxLastUpdDttm_E where JobName=<DS_SERVER_JOB>;"

 

In order for this to work you must be in the DataStage Projects folder associated with the given database instance.

 

 

-----Original Message-----
From: Srikanth Yadlapati [mailto:srikanth.yadlapati@us.ibm.com]
Sent: Tuesday, December 11, 2007 11:16 AM
To: Yadlapati Srikanth
Subject: files

 

(See attached file: EPM batch jobs info.txt)

Srikanth Yadlapati
I/T Architect
Application Innovation Services, IBM IGS
Cell: 678-773-4210
Tie Line: 546-987
srikanth.yadlapati@us.ibm.com

**********************************************************************

CONFIDENTIALITY: This communication, including attachments, is for the exclusive use of the

addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended

recipient, any use, copying, disclosure, or distribution or the taking of any action in reliance upon this

information is strictly prohibited. If you are not the intended recipient, please notify the sender

immediately and delete this communication and destroy all copies.

**********************************************************************