Which kind of index is preferred in DWH?

Question Posted / swetha

2 Answers
10537 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Which kind of index is preferred in DWH?..

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

Which kind of index is preferred in DWH?..

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

Post New Answer

More Informatica Interview Questions

What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers

What are connected or unconnected transformations?

0 Answers Informatica,

How to convert flat file into xml file? How to tune joiner?

2 Answers Accenture,

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

1 Answers IBM,

what is parameter file?

1 Answers Cap Gemini,

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers

How do you join more than 3 flat files in informatica?

1 Answers ITC Infotech,

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers HCL,

Differentiate between joiner and lookup transformation?

0 Answers

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..