Answer Posted / arun

Oracle Warehouse builder.....

What is scd1 , scd2 , scd3?

1084

---

Explain how to get the first 100 rows from the flat file into the target?

970

---

How to handle multi value dimensions?

2288

---

Explain about core dimension, balanced dimension, and dirty dimension?

1009

---

What are the steps to build the datawarehouse?

1040

---

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

1239

---

if you use oracle sql*loader , how do you transform data with it during loading?

2100

---

What are the possible data marts in retail sales?

996

---

Explain about core dimension,

985

---

Difference between cold fusion 5 and cold fusion mx 6?

994

---

Explain what are slowly changing dimensions?

1024

---

How can we run the graph? What is the procedure for that?

946

---

What is surrogate key? Where we use it?

997

---

Can we take backup when the database is opened?

1044

---

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

959

---