Behaviour of Incremental Dataflow with "save data to" option set to "db connection"
I've created an incremental Dataflow in OAC to over come the problem of "huge record set" in my datasource. My datasource has more than 10 lakhs of records and dataflow processing this dataset fails. To overcome this issue I am using incremental dataflow for which I've set, "save data to" option to "db connection".
Purpose of using this dataflow is to "incrementally add data to existing data" in the db table. I am seeing inconsistent behaviour with this dataflow. Please let me know, if some one has used "incremental dataflow"?. If yes, I would like to understand, the reliability of using it.