Answer / b siva pratap

etl tool means extract,transform and load the data into the
ware house.based on this data by using olap tool we can
generate reports

Answer / harshad

ETL Tool is used to Extrand Transform and Load data into
your Dataware house e.g. Informatica. OLAP Tool is nothing
but to design your Dataware house (more in logical) e.g.
Oracle Warehouse builder (can be use for ETL) or Siebel
Analytics (more for Dahsboard purpose but you can design
your DW)

Answer / uzval_vee

hai

In my case ETL tool is used to extract data from diffrent
sources,and make the data consistent and transformed to DWH.
olap tools are nothing but a DWH.

What is an error log table in informatica occurs and how to maintain it in mapping?

0 Answers  

---

Is there any default username & pwd for bo designer & supervisor?

0 Answers  

---

How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.

1 Answers  

---

Explain what is the difference between a primary and secondary actor in use case modeling?

0 Answers  

---

Advantages of de normalized data?

2 Answers  

---

---

What is type 2 version dimension?

0 Answers  

---

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

0 Answers  

---

How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?

0 Answers  

---

What are components of reportnet?

0 Answers  

---

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

0 Answers  

---

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

0 Answers   iGate,

---

What are aggregate fact tables ? why they are needed? give an example

2 Answers  

---