we have bitmap index, b-tree index, function based index, reverse key ind

Which kind of index is preferred in DWH?

Question Posted / ande

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Explain load alternative records / rows into multiple targets - informatica

1136

Explain the aggregator transformation?

1130

How to Create a folder using pmrep command?

1154

What are session parameters ? How do you set them?

1826

can we override a native sql query within informatica? Where do we do it? How do we do it?

1039

Which means the first record should come as last record and last record should come as first record and load into the target file?

1058

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2046

what is song in infrmatica...?

2217

What is informatica? Why do we need it?

1082

How do we call shell scripts from informatica?

1083

How to do unit testing in informatica? How to load data in informatica ?

1092

How to convert multiple rows to single row (multiple columns) in informatica

1365

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1178

What is deployment group?

1184

What is the procedure for creating independent data marts from informatica 7.1?

1045