I am creating Client Dimensions. With relationship as follows
Code: Select all
-------< clt_dim1
/
dim_clt ---------< clt_dim2
I have few questions on the design.
a) As dim_clt has to be done prior to clt_dim1, clt_dim2. Does this mean that even the extract jobs should be done prior or shall i do the extracts of all at the same time.
--> My guess all at the same time.
b) If one extract job fails, do we need to extract all - to be in sync??
--> My guess to extract all