Data Warehousing Community Forum Data Warehousing Community Forum
The Warehouse of Data warehousing knowledge ...
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
July 31, 2010, 02:36:51 am


Login with username, password and session length


Pages: [1]   Go Down
  Print  
Author Topic: Job Level Reporting through Datastage  (Read 1200 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:  



© Copyright 2006-2010 DW Forum. All rights reserved

contactSanghala | Cyber Militia | Powered by SMF | SMF © 2006-2009, Simple Machines LLC | Dilber MC Theme by HarzeM