Teradata BTET from Informtica

Question

I have a requirement to call Teradata BTET from Informatica . can any one tell me that if I create a flow ( in one single mapping ) with a ---

--dummy talble as source and target and write into its pre-sql:

begin transaction;

lock A for write;

--after this I create a my flow of mapping where I will insert data in A table

--then in last I have a flow with same dummy table whose post-sql has command

end transaction;

will this work?

Answer 1

You can write pre-SQL and pos t-SQL for the main flow itself.