Answer Posted / itsranjan

code should be like this:
Check whether the pk is present, if present, its a duplicate record.
then check for the null values
then check for invalid date columns

iif(not isnull(pk),error_code_dup_rec,
iif(isnull(col1)
or (is null(col2),null_value_
present,
or is null(date),invalid_date,valid_record))

Explain is fact table?

929

---

What is surrogate key? Explain with examples.

1146

---

What is data warehosuing hierarchy?

1161

---

How are models actually derived?

2003

---

I have two universes created by two difference database can we join them in designer & report level? How

978

---

Explain what are non-additive facts in detail?

1030

---

What are the advantages of raid 1, 1/0, and

976

---

Compare and contrast aggregates & indexes

3771

---

List any five applications of data warehouse.

937

---

What are the different types of join operations?

996

---

Explain how many ways you create ports?

1019

---

Ist the schema that a data warehouse system can implements.

934

---

Explain piconet?

958

---

Explain what are the modules in power mart?

1045

---

What are the different methods of loading dimension tables?

991

---