This content has been marked as final. Show 3 replies
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?..
Yes I have wc_twfs_olb_project_ds table already present. I can see it.
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.