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
- 17322 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
How to increase performance without changing anything in mapping.( In prod)
How to fine tune mappings?
what is different between sequential batch and concurrent batch and which is recommended and why?
Explain what are the various etl tools in the market?
what is the difference between cardinality and Nullability?
what is the use of server manager?
how would u estimate the size of Aggregator transform data and index cache?
How to delete data which is not in source table?
Difference between flat files and relational sources?
What is virtual Data Warehousing?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What is a staging area? What is the purpose of a staging area?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
Identifying the bottlenecks in various components of Informatica and resolving them.
