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.

When do we analyze the tables?

948

---

Can we create Hierarchies in generic datasources?

2372

---

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

2024

---

What is etl process? How many steps etl contains?

1025

---

Explain about round-robi?

1133

---

what is the difference between cubes and package in cognos

4941

---

what is session partitioning?

1872

---

Explain about power designer data modeling software?

848

---

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

2222

---

what are the reporting tools and difference between them?

2080

---

What are the names of the layers in etl?

986

---

Two default user groups created in the repository are____and_____.

2032

---

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

1987

---

What are the three tiers in etl?

1101

---

what is different between sequential batch and concurrent batch and which is recommended and why?

4921

---