Focal Point
Data migrator

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/1387096216

November 10, 2011, 07:58 PM
Gabe
Data migrator
I did load 4.4million records in 6 hours, I am currentely loading 1.7million records in 10 hours and still going(1.5m so far)
what am I doing wrong.


WebFOCUS 7.6
Windows, All Outputs
November 11, 2011, 10:52 AM
Clif
Is it the same flow? If not it could be many things such as a much longer record length or the number of key columns.

However the most common reasons is load type. Are you using "insert/update?" Are there duplicate keys? If so rejected record logging could be the cause. If you are using 7.7 you can view log while the flow is still running to see what's going on.

If there are no duplicate keys, then using "Insert from memory" or "Bulk load via disk file" are considerably faster, which one depends on the database and other factors.


N/A
November 22, 2011, 03:49 PM
Gabe
can you tell me how to view a logfile while the flow is still loading 7.7.03


WebFOCUS 7.6
Windows, All Outputs
November 23, 2011, 11:13 AM
Clif
Click the Run button and select Submit with Options and check Do not wait for completion and click Submit.

Then you can right click on the flow name and select logs, View Last log


N/A
November 26, 2011, 08:19 PM
Gabe
did not work for me.
I guess I have to load my flow from thw web console and then work from DMC.


WebFOCUS 7.6
Windows, All Outputs