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))

What is difference between model & package?

1021

---

Explain is fact table?

915

---

What are the stages that are required in data warehousing?

939

---

Why facts table is useful in representing the data?

985

---

What is the difference between snowflake and star schema?

1030

---

What is application.cfm?

1033

---

Can any one explain the hierarchies level data warehousing.

975

---

what are the all possible features supported modify stage?

2116

---

Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1002

---

Explain me what is vldb?

908

---

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

971

---

Explain what is the difference between datawarehouse and bi?

958

---

What are the data types present in bo?

1105

---

How can you implement many relations in star schema model?

982

---

What is the very basic difference between data warehouse and operational databases?

941

---