Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
Data migrator
 Login/Join
 
Member
posted
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
 
Posts: 20 | Registered: September 20, 2011Reply With QuoteReport This Post
Guru
posted Hide Post
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.
 
Posts: 379 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Member
posted Hide Post
can you tell me how to view a logfile while the flow is still loading 7.7.03


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 20 | Registered: September 20, 2011Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 379 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 20 | Registered: September 20, 2011Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.