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
- 18046 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 a materialized view log?
how do u handle performance issues in Informatica . where can u monitor the performance ?
what is the meaning of upgradation of Repository?
what is a worklet?
how to load the data to fact table?
Difference between flat files and relational sources?
how would u estimate the size of Lookup transform data and index cache?
What is a mapping, session, worklet, workflow, mapplet?
list and discuss two approaches for updation of target table in Informatica and how they are different.
what are the session parameters? How do u set them?
what is granularity in Data ware House?
what is session partitioning?
Which transformation we use to convert 'NA' to 'Not Available'
What is tracing level?
Identifying the bottlenecks in various components of Informatica and resolving them.
