Hi
I have a job which extracts the data from a stored procedure and upserts it in a table .
I am required to write a log file in unix ,which should contain number of rows inserted and number of rows updated in the table .
I need some suggestion as how to do it
Thanks
Arif
[Hi
Can you tell something more about the ETL stats,how can I access them from command prompt to extract the no of inserted and updated rows and write to a unix file
Well then i cant think of a way you can get the update/insert info. from the log files.
Check out kduke's ETLStats. Search for it on this forum. That might be able to help you out.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Searching for it is one thing. Finding the specific reference you are intending is another when you get 3 pages of results. Is there a particular topic you recommend? Could you post a reference?