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
- 18033 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Which transformation we use to convert 'NA' to 'Not Available'
What are the ETL Testing Operations?
what is the difference steps for data modeling?
What is a lookup table in etl?
Explain the key challenges that you face while performing etl testing.
What is full load & incremental or refresh load?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
What are the types of Data Warehouse applications?
flat filevalidation in informatica
What is tracing level and what are the types?
How many steps etl contains?
Difference between flat files and relational sources?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what are the session parameters? How do u set them?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
