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 |
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
How to do the error handling of if ur source is flatfiles?
What is informatica? What exactly are the practical uses in real world
What is the need of building a data warehouse?
What is union transformation?
if the session fails after 100 records agian we have to starts the session or we go for recovery session
Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Where is metadata stored?
Briefly describe lookup transformation?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
In development project what is the process to follow for an etl developer from day1