Answer Posted / kalpana

1. ODS is close to the source. We can say it is a replica
of source system.
While the staging area is a replica of the target DW.

2. The dimention and fact will come into picture here in
staging.

3. We are doing the Transformations in staging schema
before loading it to the target.

4. We integrate different ODS source systems into the
staging area and not in the ODS.

What is data analytics in simple terms?

1075

---

What is the difference between mapping parameter & mapping variable in data warehousing?

927

---

What are the different types of schemas used in data warehousing?

899

---

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

2054

---

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

947

---

How to join 3 database like flat file, oracle, db2 in informatrica?

1121

---

What is data warehosuing hierarchy?

1045

---

What is a general purpose scheduling tool?

1020

---

What are the different types of scd's used in data warehousing?

1179

---

What according to you might be the future of data warehousing?

939

---

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

920

---

Explain what are the possible data marts in retail sales?

931

---

i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

1921

---

Ist the schema that a data warehouse system can implements.

861

---

Where do we use semi and non additive facts?

935

---