Answer / siddu

For fast retrieval(to Perform a SELECT Operation)

Answer / vikki

GENERALLY IN DWH, WE DO SELECT QUERY ONLY(99%)..
SO THE DATA ARE NOT NEED TO BE NORMALIZED AS IN DB WHERE WE DO UPDATE,SELECT,ALTER,ETC..

Answer / ankit kansal

As a denormalized table structures for a database the number
of joins to fetch the data turns out to be less and hence selection to the data becomes faster.

selecting data from one table is always better than selecting the same data from multiple tables.


http://deepinopensource.blogspot.in/

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,

---

Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

---

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  

---

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

---

What is workflow? What are the components of the workflow manager?

0 Answers  

---

What is the advantage of informatica?

0 Answers  

---

What do you understand by term role-playing dimension?

0 Answers  

---

What are the connected or unconnected transforamations?

2 Answers  

---

what is confirmed dimension?

6 Answers  

---

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

---

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  

---

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

---