Informatica Database driver error with SQL stmt Select

0
votes

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

1
informaticadata-masking
Does the user mentioned in informatica oracle connection has SELECT access ? Can you try like SELCT ... FROM schema.table_name t0 ? - Koushik Roy
Yes. Having Select access. Able to fetch the table if mentioned along with schema name - Vasanthi
so is the issue resolved? If not, can you please post actual select query from session log? We are missing something i think. And pls ensure 1. the user is Informatica using to connect to DB is same user you are testing with. 2. You are able to issue SELECT * from schema.table using that user 3. In informatica SQL, you mentioned schemaname. tablename in SQL overwrite. - Koushik Roy
No. Issue is not resolved. - Vasanthi
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. Wish i can add a screenshot but i cant here. - Koushik Roy

1 Answers

1
votes

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. enter image description here