What is the question here ?
Looks like you may be interested in the Incremental load of Mass Ingestion feature of BDM
My question is how we can implement above use case using BDM
Did you try using the Mass Ingestion jobs and face any issues?
Can you please help me in this:-
Need to loop over the dataset1 with date time value over original dataset:
dataset1 is below :
original data set
2010-09-19 00:12:10 1
2010-09-19 00:12:11 2
2010-09-19 00:12:13 2
2010-09-19 00:13:10 3
logic is : start time =2010-09-19 00:12:10 end time=2010-09-19 00:12:25(+10 seconds of start time) ,
Now fetech records b/w start time &end time from original dataset
If you are facing any specific issues with Mass Ingestion jobs, you could raise a case with Informatica Support so that we can further troubleshoot the issue.