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
- 17823 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
What is a lookup table in etl?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
what is different between sequential batch and concurrent batch and which is recommended and why?
what are the reports developed in sap bw project and what is the requirement for developing it?
what is the difference between cubes and package in cognos
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
how do u set partition points in the mapping?
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.
what is data modeling?
Identifying the bottlenecks in various components of Informatica and resolving them.
Give the benefits of data integration suite?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
Explain do we need an etl tool? When do we go for the tools in the market?
What are cubes and olap cubes?
how do u identify the changed records in operational data?
