Currently, we are installing informatica data quality on-site. We seem to be running into an issue where while we are moving data using TPT, after the table is loaded and the session goes idle, the table becomes inaccessible and says "Table can not be accessed while being loaded" and the only way we've found to remedy this is to drop & recreate the table. Has anyone come across this issue and what was the resolution?
You can try for a "blank load" on your table, but to be honnest I don't always have 100% success with this method.
Define Job Revive_Post_Failed_Load_Operator description 'Generic job to be launch after a failed TPT LOAD' ( define operator load_operator type load standalone attributes ( varchar UserName = '<UserName>' , varchar UserPassword = '<UserPassword>' , varchar LogonMech = '<LogonMech>' , varchar TdpId = '<TdpId>' , varchar WorkingDatabase = @WorkingDatabase , varchar TargetTable = @TargetTable , integer MaxSessions = 1 ) ; apply to operator (load_operator); ) ;
It looks like Waldar's suggestion should work, because it is similar to an old Fastload workaround, but the mystery is why this happens in the first place. If you are using an Informatica tool like Power Center to load the data, then you should open an incident with Informatica, becuase that would be using the TPT API rather than a TPT script. On the other hand, if you are using your own TPT script, it might help to share it with us.