Hello every one,
I am new to this field, I am getting error when I run my workflow in other folder, It is giving table or view does not exist, And I understood that the target table is not present,
Actual table present is ws_twfs_olb_project_ds but in the session log it is showing wc_twfs_olb_project_ds1. I don't know why in the session log it is showing like that.
Might be the problem occured during the importing session. If so, Can you please provide me how to resolve this issue.
Thanks in advance!
wc_twfs_olb_project_ds1 is an alias table and used in Informatica mapping to do self join(specifically in order to query different column multiple times).
Ideally you sholud be checking the wc_twfs_olb_project_ds in the OLAP schema.Try connecting to OLAP scheam by toad or SQL*PLUS and let me know if you are able to view this table or not?..
Are there two instance of this target table- ws_twfs_olb_project_ds in this map? If yes, Informatica designed automatically renames the second one appending 1 in the end. However if you double click the the target definition inside map you can see actual name.