Data Warehousing Community Forum
February 10, 2012, 01:01:39 am
Home
Help
Search
Login
Register
Data Warehousing Community Forum
>
ETL Tools
>
Data Stage
>
Job Level Reporting through Datastage
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: Job Level Reporting through Datastage (Read 2253 times)
ccotton333
DW Fresher
Reputation: +0/-0
Offline
Posts: 1
Job Level Reporting through Datastage
«
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
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> Introductions
=> Anouncements & News
=> Suggestions
=> General Discussion
=> Job Opportunities
-----------------------------
Data Warehousing
-----------------------------
=> Data Warehousing Concepts
=> Data Modeling
-----------------------------
Databases
-----------------------------
=> Oracle
===> PL/SQL
=> Microsoft SQL Server
=> IBM DB2
=> Teradata
-----------------------------
ETL Tools
-----------------------------
=> Informatica
===> Installation & Configuration
=> Data Stage
=> Ab Initio
=> Oracle Warehouse Builder
=> DTS/SSIS
-----------------------------
Reporting Tools
-----------------------------
=> Business Objects
=> Cognos
=> Crystal Reports
=> Hyperion
=> Brio
=> Microstrategy
-----------------------------
Operating Systems
-----------------------------
=> UNIX / Linux
===> Unix Shell Scripting
=> Windows
-----------------------------
Other Technologies & Tools
-----------------------------
=> JAVA