sample script to use sql commands in informatica cloud pre/post processing

Question

Required sample script to run sql commands through pre/post processing commands. I tried by using sqlcmd but I'm getting this -

I CMN_1949 Error: [Pre/Post Session Command] Process id 5540. The shell command failed with exit code 1.

Answer 1

Use Pre SQL and Post SQL properties of your Target defined in the session's Mapping tab. There you can use pure SQL statements directly, there's no need for any shell scripting at all.

Answer 2

Trying running your script in bash to see what the real error is.