Which kind of index is preferred in DWH?

Question Posted / mkselva

3 Answers
12285 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

Is it possible to define a single node as a Gateway node as well as worker node?

0 Answers

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers HCL, Schneider,

What is the difference between a router and a filter transformation?

1 Answers TCS,

design of staging area?

0 Answers

How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

1 Answers CTS,

In which scenario did u used Mapping variable?

1 Answers Cognizant,

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers CTS,

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers IBM,

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers

After we make a folder shared can it be reversed?Why?

2 Answers Accenture,

When to use normalization transformation other than cobol source?

2 Answers

How do you take back up of repository?

0 Answers

For more Informatica Interview Questions Click Here