Question

PreSQL and postSQL in Informatica is not getting executed.

ISSUE DESCRIPTION :

I have table in Microsoft SQL server. I am trying to update/insert this table using Informatica powercenter session by calling SP through Stored Procedure Transformation. But its not happening. After further digging up, I got to know that reason behind this are triggers on table that we are trying to update/insert. There are couple of triggers defined on the table and it has got on insert and on update triggers also. So I thought of disabling all the triggers on the table in PreSQL and enable them back again in postSQL of the session that I am running. But its not working. However when I execute the trigger disable statement directly on DB through Microsoft SQL server client and run the session, session is updating/inserting the records.

Below are the Presql and postSQL commands used by me:

BEGIN TRANSACTION
ALTER TABLE schemaname.tablename DISABLE TRIGGER ALL
commit;

BEGIN TRANSACTION
ALTER TABLE schemaname.tablename ENABLE TRIGGER ALL
commit;

Please let me know if I am going wrong anywhere/if there is any possible resolution for this.

Answer 1

your sql gets parsed by powercenter before going to the db.

Check the server config - there should be some option to send unparsed sql.