Interested to Buy Any Domain ? << Click Here >> for more details...
how to answer the question "explain project architecture" in
informatica
pls any one who has the answer pls send the answer to this
mail id
"karumanchisrinu@gmail.com
- 2 Answers
- 17804 Views
- TCS, I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
what are the concerns of OLTP and DSS systems?
tell me few points when u become TL
what are the cubes developed in a sap bw project and what is the requirement for developing it?
how does the server recongnise the source and target databases.Elaborate on this
What is virtual Data Warehousing?
Is hadoop a etl tool?
What is meant by incremental load?
What is tracing level?
Explain me ETL project architecture in Detail?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
what is the main role of FI on business
What are the ETL Testing Operations?
how many maximum session supports to multiload in teradata ??
What are dimensions?
What is staging area referring to?
