Which kind of index is preferred in DWH?
Answers were Sorted based on User's Feedback
Answer / ande
we have bitmap index, b-tree index, function based index,
reverse key index and composit index. we will use bitmap
index in DWH
Regards,
ande
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / ghouse
to load the data into the fact table b tree index is created
and bit is used where the cordinality of the coloumn is very
low i.e(in dwh-denormalised one)(OLAP)
| Is This Answer Correct ? | 1 Yes | 1 No |
How does the session recovery work.
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
Different types of Power center errors?
What is the procedure to load the fact table.Give in detail?
can anyone suggest best free Talend data integration training online
Which development components of informatica have the highest usage?
AT the max how many transformations and mapplets can we use in a mapping ?
1 Answers Cap Gemini, Cognizant,
What is a test load?
what is size of u r database?
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
What are roles and groups and benefits of using them?
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you