count the number of inserts

dodda · Post by **dodda** » Mon Jun 01, 2009 12:04 pm

Hi

i have a requirement where i need to read a fixed width flat file and insert the rows into a oracle DB. My input File has detailed records and Footer record. records will be inserted into database based on some constraints.
I need to capture the no of records that got inserted and that number has to be inserted into a Database. Need your help on how to capture the records and insert them into a database.

Thanks

DSguru2B · Post by **DSguru2B** » Mon Jun 01, 2009 12:24 pm

Really depends on how you are identifying your inserts, if its predetermined and all you are doing is inserting records then you can get the link count. Search for several methods discussed here.
If its insert/update then you could do a count(*) on your target table after the inserts.

dodda · Post by **dodda** » Mon Jun 01, 2009 12:32 pm

Hello DSGuru

The number of inserts vary as we will do some constraint check just before we do insert into database. i want to write number of records that got inserted to a file and in the next job i will read that file to get the number of records that got inserted.

thanks

dodda · Post by **dodda** » Mon Jun 01, 2009 1:42 pm

Hello Guru,

Is there a way i can get and write the Job start time, endtime, Status, no of records inserted into a file

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon Jun 01, 2009 4:29 pm

No, unless you timestamp or otherwise identify the run, and count the table beforehand and afterwards.

In DataStage you can only count the number of rows SENT to the database server - whether they get inserted successfully or not is a different question.

Download ETLstats, which already exists and will do most of the process metadata capture for you.