Home » Developer & Programmer » Warehouse Builder » synchronous capture (11.2.0.1.0)
synchronous capture [message #537477] Wed, 28 December 2011 15:27
shree_z
Messages: 64
Registered: February 2008
Member
I am new to synchronous capture and apply processes.

I am trying to implement a simple transformation.

If a row is inserted into source table, I want the new record to be unpivoted and placed in a destination table.

Source table is created as follows:

CREATE TABLE HR.PIVOTED_DATA
		 (id NUMBER, 
		   customer_id NUMBER,
		  product_code_a NUMBER,
		   product_code_b NUMBER,
		   product_code_c NUMBER,
		  product_code_d NUMBER);

COMMIT;

INSERT INTO hr.pivoted_data VALUES (1, 101, 10, 20, 30, NULL);
INSERT INTO hr.pivoted_data VALUES (2, 102, 40, NULL, 50, NULL);
INSERT INTO hr.pivoted_data VALUES (3, 103, 60, 70, 80, 90);
INSERT INTO hr.pivoted_data VALUES (4, 104, 100, NULL, NULL, NULL);
COMMIT;


destination table structure is as follows:
CREATE TABLE HR.PIVOTED_DATA
		 (id NUMBER, 
		   customer_id NUMBER,
                   product VARCHAR2,
                   Quantity NUMBER)
]
I have created the apply process. Now the next step is to do the custom transformation. How do I achieve this "unpivot" transformation in the apply process?


Thanks in advance,
Shree_z



Previous Topic: Data warehouse help
Next Topic: Verifying Dimensional Model
Goto Forum:
  


Current Time: Tue Jul 29 02:19:15 CDT 2014

Total time taken to generate the page: 0.05483 seconds