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
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 would u estimate the size of Aggregator transform data and index cache?
how do use session mapping parameters ?(in which transformation)
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
What is cube grouping?
what are the facilities provided by data warehouse to analytical users?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
What is etl tool in hadoop?
Explain about the data integration suite features?
how do u extract data from different data sources explain with an example?
What is abap? What are idocs?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What is Data Vault???
how does the server recongnise the source and target databases.Elaborate on this