First of all, thanks a lot for making and sharing such great tutorials, appreciate ur kind gestures a lot. I have couple of doubts as well which I am listing below- 1. How do sequence generator knows if it is not generating and using a existing DB surrogate key values. Can we read from existing DB sequence via that generator? 2. When you try to use same sequence to insert same table multiple times in parallel, then I assume we will end up inserting values not in a proper order. What if we end up inserting 10 brand new records first and then insert the once for a updated one. Can we control this behavior? 3. Do we end up creating 3 DB sessions- 2 for inserts and one for update? 4. Can we control the order in which we perform inserts and updates? Can we perform inserts and updates in single target session? Is there any such property? 5. Can you also show how to build customized target insert and update queries? I am planning to do Upsert in the same target session and control insert/update based on flag value in the target query. Do you see any drawbacks in my approach? I will put further clarifications if come up with more questions. Thanks
Instead of 2 filters can 1 router be used to have groups for O_New_Record and O_Update_Record? When you do the lookup your SQL override adds the Where condition Flag = 1. Instead of SQL Override, can you specify 'Flag = 1' in Lookup Source Filter? Last thing, in practice, if this is running daily, would you set your Sequence Generate to reusable to ensure that the repository keeps incrementing the current values and Nextvals? Thank you, very informative video!
Hey, Actually, I followed the same steps as given in this video but after started workflow I am getting duplicated records into target table into database and update flag is also not working. Please, help me.
First of all, thanks a lot for making and sharing such great tutorials, appreciate ur kind gestures a lot.
I have couple of doubts as well which I am listing below-
1. How do sequence generator knows if it is not generating and using a existing DB surrogate key values. Can we read from existing DB sequence via that generator?
2. When you try to use same sequence to insert same table multiple times in parallel, then I assume we will end up inserting values not in a proper order. What if we end up inserting 10 brand new records first and then insert the once for a updated one. Can we control this behavior?
3. Do we end up creating 3 DB sessions- 2 for inserts and one for update?
4. Can we control the order in which we perform inserts and updates? Can we perform inserts and updates in single target session? Is there any such property?
5. Can you also show how to build customized target insert and update queries? I am planning to do Upsert in the same target session and control insert/update based on flag value in the target query. Do you see any drawbacks in my approach?
I will put further clarifications if come up with more questions.
Thanks
Nice ... Worked
❤❤❤
Why don't u choose data driven from session property when u r using Update Strategy? How is it working I can't understand.
Instead of 2 filters can 1 router be used to have groups for O_New_Record and O_Update_Record?
When you do the lookup your SQL override adds the Where condition Flag = 1. Instead of SQL Override, can you specify 'Flag = 1' in Lookup Source Filter?
Last thing, in practice, if this is running daily, would you set your Sequence Generate to reusable to ensure that the repository keeps incrementing the current values and Nextvals?
Thank you, very informative video!
thank you
IN FILTER WHY CANT THE CONDITION BE TRUE INSTEAD OF NEW_RECORD OR UPDATE_RECORD great thanks for answering in advance
Hey, Actually, I followed the same steps as given in this video but after started workflow I am getting duplicated records into target table into database and update flag is also not working. Please, help me.
Nuvvu malli raavali.