Answer Posted / makkenasrinu

Architecture
1. Source systems: like mainframe,oracle,people soft,db2.
2. Landing tables: these are tables act like source. Used
For easy to access, for backup purpose, as reusable for
Other mappings.
3. Staging tables: from landing tables we extract the data
Into staging tables after all validations done on the data.
4. Dimension/facts: these are the tables those are used for analysis and make decisions by analyzing the data.
5. Aggregation tables: these tables have summarized data
Useful for managers who wants to view monthly wise sales,year wise sales etc.
6. Reporting layer: 4 and 5 phases are useful for reporting developers to generate reports. I hope this answer helps you.

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

998

---

Do we need an ETL tool? When do we go for the tools in the market?

957

---

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2626

---

Explain about power designer data modeling software?

848

---

how do use session mapping parameters ?(in which transformation)

2014

---

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2555

---

flat filevalidation in informatica

2152

---

What is full load & incremental or refresh load?

1203

---

what is the difference steps for data modeling?

2596

---

what are the production issues in datastage?

10420

---

how do u set partition points in the mapping?

2239

---

what is pmrep command?

11575

---

what are the concerns of OLTP and DSS systems?

2446

---

can be used COM component in Informatica ?

2059

---

Explain different types of partitioning?

1041

---