Get no. of rows inserted and updated

mab_arif16 · Post by **mab_arif16** » Wed May 10, 2006 12:02 pm

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

DSguru2B · Post by **DSguru2B** » Wed May 10, 2006 12:42 pm

Are your inserts and updates from a single Stage. Or you are splitting the inserts and updates?

kduke · Post by **kduke** » Wed May 10, 2006 1:02 pm

Search for EtlStats.

mab_arif16 · Post by **mab_arif16** » Wed May 10, 2006 1:08 pm

DSguru2B wrote:Are your inserts and updates from a single Stage. Or you are splitting the inserts and updates?

They are form a single stage and loaded into the database using upsert method

mab_arif16 · Post by **mab_arif16** » Wed May 10, 2006 1:10 pm

[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

DSguru2B · Post by **DSguru2B** » Wed May 10, 2006 1:14 pm

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.

bcarlson · Post by **bcarlson** » Wed May 10, 2006 1:36 pm

kduke wrote:Search for EtlStats.

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?

Brad.

DSguru2B · Post by **DSguru2B** » Wed May 10, 2006 1:51 pm

Try thisfor a start.
You can also download it from kduke's tips page.

kduke · Post by **kduke** » Wed May 10, 2006 4:50 pm

Try viewtopic.php?t=92213 or this one viewtopic.php?t=93189&highlight=EtlStats