Data Warehousing Community Forum
February 10, 2012, 01:01:39 am

Pages: [1]   Go Down
  Print  
Author Topic: Job Level Reporting through Datastage  (Read 2253 times)
ccotton333
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 1


View Profile
« on: April 01, 2009, 11:46:32 pm »

I'm fairly savvy with DataStage 7.5.2, but i have come across a situation that I would imagine someone has found a solution for.  I would like to at the end of my jobs in DataStage to load the process statistics into a table in our DW.  For example, i have a sequential file stage, transformer, and Teradata API. I want to have 3 seperate entries. one being the sequential file stage name, link name leaving file, number of row sent over the link. Another being the transformer stage name, link names (input and output), number or rows received and/or sent over each link (so basically 2 records with transformer data). and the file being the teradata api stage name, link name, number of rows recieved, updated,deleted,inserted.  I know that there is probably a tool out there that will do it for you, but I have searched and search with no luck.

Thanks in advance.
Logged
Pages: [1]   Go Up
  Print  
 
Jump to: