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

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2188

---

Explain what are data marts?

1206

---

What is the difference between er modeling and dimensional modeling?

1194

---

Explain what is fact less fact table? Where you have used it in your project?

986

---

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

1031

---

How do you define data block size?

1101

---

How can you set the client management?

1063

---

Explain what are components of reportnet?

1029

---

Explain what are components of report studio?

1176

---

what are the all possible features supported modify stage?

2227

---

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1145

---

I need a good brd and uc template?

1145

---

What is the differences between star and snowflake schemas?

1120

---

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

1018

---

Explain what are the steps to build the data warehouse?

996

---