As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
I developed a dataflow with Source, Target and corresponding tranformations. My Source table contains around 1 million records. The flow is valid and when I ran the Process flow, it started fetching the records and loading it into target. It took more than 4 hours and it is still not completed. So, I cancelled the process flow.
Later, I noticed the table got loaded with some amount of records. But, I increased the commit size greater than source record count.
My question is, will the process flow run in the background?. If so, where to go and stop it?.
A couple of things: 1) to cancel go to console, then workspace then data services; right click and select agents. You should see your request running. Right click on it and seletc "kill this agent" 2) I suspect the reason your job is taking so long is that you are using "keyed update". If possible avoid that and use "insert from memory"