Count of successful rows from Oracle Merge

Question

Hi,
I have a requirement to record the successful row count from Oracle Merge Snap. this is to maintain the Data Log table. Is there any way to know the successful rows from Oracle Merge. i saw something in Mapper (snap.out.totalCount).
Please someone can advice on this one

pranil2k2 · Answer

finally i achived it using Mapper, Aggregator.

pranil2k2 · Answer

Hi,
Please someone advice on this one.
Thanks

supratim · Answer

@pranil2k2
Go to Oracle Marge view and add output view. After that use aggregate snap for count.

spirotaleski · Answer

Hi @pranil2k2
You can try by opening the error view for Oracle Merge Snap(meaning that all the error rows will be routed in that view). In that way you will isolate the pipeline from failing.
As an output of the Oracle Merge Snap you will get all successful records.
To count the records from output you can use :

snap.out.totalCount - you will get total number of documents that have passed through.
Use Aggregate Snap(function Count) on some unique column(field).

Regards,
Spiro

pranil2k2 · Answer

Hi Spiro,
Thanks for the reply.

Forum Discussion

Count of successful rows from Oracle Merge

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?