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

How are the sources and targets definitions imported in informatica designer?

1107

What can we do to improve the performance of informatica aggregator transformation?

1093

What is the Rank index port in Rank transformation?

1059

what is size of u r database?

2305

What are the steps involved in the migration from older version to newer version of Informatica Server?

2107

Why sorter is an active transformation?

1189

How many types of sessions are there in informatica.please explain them?

1165

What is event and what are the tasks related to it?

1122

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2720

What is the Process to creating lookup transformation in informatica

1043

what is the -ve test case in your project.

2407

How can we store previous session logs?

1078

What is a node in Informatica?

1041

What is DR strategy for Informatica project?

1185

What are the mapping parameters and mapping variables?

1204