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
- 17924 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / asdf
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 ? | 0 Yes | 0 No |
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
What is etl tool in hadoop?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Do we need an etl tool?
What is a mapping, session, worklet, workflow, mapplet?
what is pmrep command?
Two different admin users created for repository are________and_________.
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
Which type or t/s is used to convert rows into column & column into rows
what are business components in Informatica?
What are materialized views & where do we use them?
Teradata 
