WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ?
Thanks In advance Prakash
Answers were Sorted based on User's Feedback
Answer / interested
In general the same index theory applies to DW as it is for
any RDBMS. So we can have one clustered index and several
non-clustered indexes on a table. defininng the index
depends on the need for the particular SQL. We usually
define them on the columns used in the join clause and in
the where clause to fecilitate the faster fetch.
Is This Answer Correct ? | 1 Yes | 4 No |
what types of challenges we are faced in creating web i reports .can you please explain with some examples.
2 table is there , thats column is different name but data type is same, 2 tables values are same. how to you findout both values are same?
what is universe testing(not mention check integrity)
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
how do u migrate BO 6.x to XI ?
52 Answers Cognizant, HCL, IBM, Wipro,
i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)
How many universes are required for a single project,and how many reports are required for a single Universe.
Can we take report on Excel in Business Objects?
6 Answers Business Intelligence Analytics, Oracle,
Can anybody tell me what are the tuning problems?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?
What is Array bind size in universe? Plz