I have a product User and some nested tables in it. One of them is ProductDocument Table. I wrote creation script of nested type, and the ProductDocument table below for better understanding.
I designed a dimension and tried to map values to dimension table from ProductDocument table.
I tried using expand_object component (I choose Type_Document in expand object because there was no Document). But DocumentId in ProductDocument table's type is Document and expand object was type_document this made an error. I also tried to use anydata cast component in this case i got "PLS-00302: component 'GETTYPENAME' must be declared" error. My experimentations was unsuccessfull.
What is the way of transferring data from nested table to dimension table.
-CREATE type Type_Document as object(
-CREATE TYPE Document AS TABLE OF Type_Document;
-CREATE TABLE ProductDocument(
ProductID number NOT NULL,
ModifiedDate date NOT NULL)
NESTED TABLE DocumentId STORE AS Document_TABLE;
Hi i solved my problem by trying.
I used varray iterator component from component palette, which takes document type attribute as input and type_document type attribute as output.
I also put an expand object component and binded output of varray iterator as input.
Finnaly i bind required attributes to dimension table. My mapping finnally worked successfully :)