Answer / Ashutosh Kumar Srivastava

IBM's PowerCenter (previously known as DataStage) is an ETL (Extract, Transform, Load) tool used for data integration and transformation tasks. It can extract data from various sources, transform it according to business rules, and load it into a target system like a data warehouse or operational database. On the other hand, IBM's Power Mart (previously known as DB2 Warehouse Manager) is a suite of tools for building and managing data warehouses. It includes capabilities for data modeling, data loading, data administration, and query optimization.

What needs to be done while starting the database?

1 Answers  

---

What is the function of etl when used in data warehousing?

1 Answers  

---

What is the difference between constraind base load ordering and target load plan?

1 Answers  

---

Hi Cognos Folks, I have all cognos certification dumps. In fact i am certified in most of the dumps recently. I have cognos material, pdfs, user guides, documents along with dumps. If any one required cognos dumps, please drop me mail at cognos.biuser@gmail.com Thanks, Cognos bi user

13 Answers   IBM,

---

Explain me what are data marts?

1 Answers  

---

Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

1 Answers  

---

What are data modeling and data mining? Where it will be used?

1 Answers  

---

Explain is fact table?

1 Answers  

---

waht is the advantage of infoset query

0 Answers   iGate,

---

What is a fact table?

1 Answers  

---

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

1 Answers  

---

What is query panel?

1 Answers  

---