Answer Posted / annobw
It should have around 10-20% of the size of fact table;
for ex: if fact table contains 1 million rows the aggregate
should have less than 200,000 rows
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to fetch the data from sap-r/3, sap-bw/bi to informatica system? what is step by step procedure? at what senario you retrieve the data from sap system to informatica or say dwh system? --
What is an exception cell?
What are the data target administration tasks?
How would you do the calling a bw query from an abap program.
How do I send really complex mails from the workflow?
What are the steps to create classes?
What are the types of reports you can use in reporting agent?
describe how you have used excel as a compliment to bex?
Explain web template?
What is transactional ODS object?
Can you tell something about the multi-provider in the sap and how it is useful for the users?
what is high cardinality tell me brief
What are the proposal options available?
What is the procedure to create a data mart?
Tell something you know about the dimension in the warehouse and how it can be optimized?