ccotton333
DW Fresher
Reputation: +0/-0
Offline
Posts: 1
|
 |
« 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.
|