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
- 17345 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?
Is apache nifi an etl tool?
what are the production issues in datastage?
How many steps etl contains explain with example?
Explain me ETL project architecture in Detail?
what are the facilities provided by data warehouse to analytical users?
Explain and compare etl & manual development?
list and discuss two approaches for updation of target table in Informatica and how they are different.
where are the log files generally stored.Can you change the path of the file.what can the path be?
What is tracing level?
how do u extract data from different data sources explain with an example?
What are the three tiers in etl?
Can we create Hierarchies in generic datasources?
What is staging area referring to?
what is the main role of FI on business
