I am trying to trace execution of Informatica workflow against SQL Server 2008.I don't see any activity on the trace during this execution.Is it possible to do this?
If it's making calls to the database you should be to see them. If you're not seeing them, there must be something wrong with your trace configuration, server settings, filters... something along those lines.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" - Theodore Roosevelt