Running a Data Flow


When you have made all of the data preparation transformations for a flow, and have added your target, on the toolbar click the Run button ().

When the data is loaded, a report similar to the following displays. 

(ICM18122) Request - citibike/dflow02.fex (Owner: USER1) submitted. 
(ICM18741) citibike/citibike_tripdata01 type Hyperstage (PG) New target 
(FOC2662) BULK LOAD PROCESS STARTED AT 12.05.04
(FOC2661) TARGET FILE CITIBIKE/CITIBIKE_TRIPDATA01
(ICM18950) Command Invoked to Load Data: C:\ibi\srv82\ibi\srv82\home\hs\bin\dlp.exe
(ICM18745) Commit forced at: 1000000 for 1000000 row(s)
(ICM18745) Commit forced at: 2000000 for 1000000 row(s)
(ICM18745) Commit forced at: 2077758 for  77758 row(s)
(FOC2663) BULK LOAD PROCESS ENDED AT 12.07.29, ELAPSED TIME = 00:02:25.219
(FOC2661) TARGET FILE CITIBIKE/CITIBIKE_TRIPDATA01
CITIBIKE/citibike_tripdata01 HELD AS SQLHYPG TABLE
1 
0 NUMBER OF RECORDS IN TABLE=  2077758  LINES=2077758
0 
(ICM18744) Ending Load 
(ICM18040) Return Code = 0      
(ICM18076) Request: citibike/dflow02.fex - finished processing 
(ICM18007) CPU Time : 106125