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
- 17809 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 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 are materialized views & where do we use them?
how does the server recongnise the source and target databases.Elaborate on this
What are the types of Data Warehouse applications?
What are your responsibilities as an etl tester?
what are the types in error loging?
State the differences between shortcut and reusable transformation
list and discuss two approaches for updation of target table in Informatica and how they are different.
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
what is different between sequential batch and concurrent batch and which is recommended and why?
Explain about etl data integration software?
how do u set partition points in the mapping?
dimension object created in oracle can be imported in designer?how?
how do u handle performance issues in Informatica . where can u monitor the performance ?
what is Forward,Reverse and Re_engineering?
