Does fast load maintain a temporary work table that is loaded in the phase1 and then in the phase 2 data is put into target table(vdisk).Then the temporary work table dropped.Is there anyway to access the worktable. How is lock on the target table is released in case of fast load using a dummy script.
FastLoad performes operation on only 3 tables during Begin Loading Phase. first one is Empty Fastload Table and two error tables.after begin Loading Phase Locks are released from this 3 tables so End Loading Hash Distributes the data. No Temp Tables are invoved during the Process. Hope this will clarify the Issue.