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
- 16862 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 is the use of server manager?
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
Explain about etl data integration software?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
Explain about power designer data modeling software?
dimension object created in oracle can be imported in designer?how?
When do we analyze the tables?
what is Forward,Reverse and Re_engineering?
how do use session mapping parameters ?(in which transformation)
what make u disappointmnets in u r career
Define Dynamic push down optmization?
what is the use of server?
what is dynamic insert?
Do we need an etl tool?
what is different between sequential batch and concurrent batch and which is recommended and why?
