Which kind of index is preferred in DWH?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the cumulative sum and moving sum?

751


What will be the approach?

575


what is the Default Source Option For Update Strategy Transformation?

751


write a query to retrieve the latest records from the table sorted by version(scd)

628


What is the use of source qualifier?

663






Explain incremental aggregation in informatica

650


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1547


What are the tasks that source qualifier perform?

628


Plz can any one say me how to get the informatica certification materials and dumps

1591


Is stop and abort are same in informatica?

568


What is the sequence generator transformation in informatica?

609


Explain lookup transformation is active in informatica

657


what is size of u r database?

1844


Write the different tools in the workflow manager?

569


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1677