Which kind of index is preferred in DWH?
Answers were Sorted based on User's Feedback
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 |
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
How do you take back up of repository?
when will we go for unconnected lookup transformation in Informatica?
What is the main difference between a Joiner Transformation and Union Transformation?
What is meta data and system catalog?
can anyone explain me about sales project in informatica?
Differentiate between a repository server and a powerhouse?
Explain the different dimensions.
what are objects in data warehouse?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
What is a rank transform?