Informatica Data Quality not releasing table

Database
Enthusiast

Informatica Data Quality not releasing table

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?

2 REPLIES
Teradata Employee

Re: Informatica Data Quality not releasing table

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[1]);
    
)
;
Teradata Employee

Re: Informatica Data Quality not releasing table

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.