1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Which kind of index is preferred in DWH?

Question Posted / mkselva

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 is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

Does an informatica transformation support only aggregate expressions?

0 Answers  




what is size of u r database?

0 Answers  

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

0 Answers   Amazon,

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

What is the Difference between PowerPlay transformer and power play reports?

1 Answers  

Implementation methodology

0 Answers  

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

For more Informatica Interview Questions Click Here
Categories