Answer / vasu bathula

DataMart is a subset of data warehouse and it is supports a
particular region, Business unit or business function.

Answer / swamy.l.n

1.A DATA MART IS SUBJECT OF ENTERPRICE DWH.
2.A DATA MART IS SUBJECT ORIENTED D-BASE WHICH SUPPORT THE
BUISINESS NEEDS OF MIDDLE MANAGEMENT OR INDUISUAL
DEPORTMENT IS IN ENTERPRICES.
3.A DATA MART IS ALSO KNOWN AS "HIGH PERFORMENCE QUERY
STRUCTURE".
DATA MARTS ARE TWO TYPES:-
1.DEPENDENT DM:-
IN A TOP-DOWN DWH APPROACH A DM DEVELOPMENT DEPENDED
UPON ENTERPRISE DWH.
2.INDIPENDENT DM:-
IN A BOTTOM-UP DWH APPROACH DM DEVELOPMENT IS IN
DEPENDENT UPON ON INDIPENDENT DWH.

How to use the tool Ontobulider

1 Answers  

---

Explain dimensional modelling?

0 Answers  

---

I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE

1 Answers   Wipro,

---

Explain datawarehousing?

0 Answers  

---

Explain if a flat file cotains 1000 records how can I get first and last records only?

0 Answers  

---

How to answer the question how many fakt table in your datawarehouse and what size it have?

3 Answers   Cap Gemini,

---

2.What is staging area ?

4 Answers   HCL, IBM, iFlex, TCS,

---

what are different ways of loading data to data warehouse using oracle?

1 Answers  

---

Explain what is a staging area? Do we need it? What is the purpose of a staging area?

0 Answers  

---

What are modeling tools available in the market?

0 Answers  

---

Explain how many ways you create ports?

0 Answers  

---

if source contain 10records how you identify header and footer

2 Answers   Polaris,

---