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 difference between snow flake and star schema.

720

---

What is the advantages data mining over traditional approaches?

720

---

What are Aggregate tables?

903

---

Explain the main difference between inmon and kimball philosophies of data warehousing?

738

---

How to import vsam files from source to target. Do we need a special plugin?

713

---

What is data analysis?

727

---

Is there any rownum object from which we can do this?

705

---

Explain reference cursor?

1879

---

Explain what is cost benefit analysis (cba)?

727

---

Explain difference between e-r modeling and dimentional modeling?

751

---

How many types of facts and what are they?

730

---

Explain what are fact, dimension, and measure?

717

---

What are the differences between star and snowflake schema?

712

---

Difference between e-r modeling and dimentional modeling?

667

---

what is an use case?

801

---