Junk Dimension

Question 1

Alter table to add a JUNKID

Answer 1

Alter table xxxDIM add (junkID number(2))

Question 2

Create a Junk dimension

Answer 2

CREATE TABLE JunkDim AS SELECT DISTINCT a, b, c, d from dw.xxx

Question 3

Create a tempfact table

Answer 3

Create table tempfact as select a, b, c, d from dw.xxx

Question 4

Add junkid to tempfact

Answer 4

Alter table tempfact add (junkid num(2))

Question 5

Set sequence to tempfact

Answer 5

Update tempfact tf set tf.junkID = (select j. junkID from junkDIM j where j. aaa = tf.aaa and j. bbb = tf. bbb and j. ccc = tf. ccc and j. ddd = tf. ddd)

Question 6

Create sequence for junkDIM

Answer 6

Create sequence junk.seq_id start with 1 increment by 1 maxvalue 99999999 minvalue 1 nocycle

Question 7

Update junkDIM with the ID set to sequence ID

Answer 7

update junkDIM set junkID = junk.seq_id.nextval