Which kind of index is preferred in DWH?

Question Posted / mkselva

3 Answers
12188 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Which kind of index is preferred in DWH?..

Answer / pushparao

bitmap index

Is This Answer Correct ?

8 Yes

1 No

Which kind of index is preferred in DWH?..

Answer / sri47

It Actually depends on the nature of the Column on which
you are goint to create an index.

Bit Map: If the column is of type Flag means contains 1 or
0.
Binary: If the column cintains numerical values.

Partitions also can be created if column values contains
only some list of values .

Is This Answer Correct ?

2 Yes

0 No

Which kind of index is preferred in DWH?..

Answer / raj

Unique primary key index

Is This Answer Correct ?

0 Yes

2 No

Post New Answer

More Informatica Interview Questions

What are the rank caches?

2 Answers Informatica,

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers

what is the hint? how to use it to reduce the query processing in program?

3 Answers Cegedim,

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers Informatica,

Mention few power centre client applications with their basic purpose?

0 Answers

can we load the data with out a primary key of a table? what is target plan?

6 Answers IBM,

What is data movement mode in Informatica and difference between them?

0 Answers

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?