if a customer changes his or her zipcode what is the implication of this in the data warehouse?

1. this is slowly changing dimension and we need to preserve history so we do type 0 change

2. this is slowly changing dimension and we need to overwrite history so we do type 0 change

3. no changes need to be done to reflect this

4. both numbers 1 and 2 are correct

surrogate keys are?

1. natural keys

2. used in databases

3. used in conjunction with natural keys in the data warehouse

4. used in data warehouses and not in operational databases