How to find staging tables
621506Mar 5 2008 — edited Mar 6 2008Hi,
I have a able in source schema, dann made a mapping in the staging area (staging schema), make a staging table from source table, dann going to core dwh to deploy the table and mapping which i made. I can valide and generate the mapping and staging table. But if i try to deploy the mapping i will get the message, that the table doese not exits, even the building was ok.
Looking into he three schemas, will not able to find the stging table. It is true when the object is not in staging schema, i will get the error.
My question ist:
How i cn find the stging table???
Here i a part of package:
CURSOR "XX_STAGE_c$1" IS
SELECT
"XX_STAGE"."aa" "bb",
"XX_STAGE"."cc" "dd"
FROM
"AA_ST"."xx_STAGE" "xx_STAGE";
Here is the eroor message:
Row-# = 11 Column-# = 3 Error text = PL/SQL: SQL Statement ignored
Row-# = 17 Column-# = 14 Error text = PL/SQL: ORA-00942: Table or view does not exists
Thanks in advance
Mandi