Informatica Database driver error with SQL stmt Select

Facing below error while executing the job in informatica TDM.

SQL error Table or view does not exist Database driver error Function name : Execute SQL stmt : select t0.col name1 as "col name1", t0.col name2 as "col name2" from tablename t0 Oracle fatal error Prepare failed Rolling back all the targets due to fatal session error

Solution

There is an option in session > mapping > target. Edit session, go to 'Mapping' tab. Then select the target, go to properties section on right pane. scroll down and find 'table name prefix'. Mention your schema name there.