What r the type of indexes u generally used in informatica?

Question Posted / guest

2 Answers
18943 Views
Keane India Ltd, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What r the type of indexes u generally used in informatica?..

Normally we use two types of indexes in informatica.
Btree Index
Bitmap Index

Bitmap Index gives better performance than Btree Index.

Is This Answer Correct ?

10 Yes

1 No

What r the type of indexes u generally used in informatica?..

Answer / javidakram

b tree and bitmap indexes we r using in informatica. b tree
is low cardinality and bitmap have high cardinality that is
why bitmap index gives better performance.

Is This Answer Correct ?

6 Yes

2 No

Post New Answer

More Informatica Interview Questions

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers CTS,

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers Patni,

Why we select the table which has minimum number of records as Master table in joiner?

4 Answers HG, UST,

is it possible to index the data in cache of lkp transformation ?

0 Answers

Where is the cache stored in informatica?

5 Answers Infosys, Satyam,

Explian the Process of deployment groups in informatica

0 Answers Informatica,

who to split dimentions into sub dimention

3 Answers Wipro,

Is it possible to create multiple domains on a single Informatica server?

0 Answers

What is option by which we can run all the sessions in a batch simultaneously?

0 Answers Informatica,

What are the informatica performance improvement tips

0 Answers Informatica,

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers

What are the mapping paramaters and mapping variables?

1 Answers

For more Informatica Interview Questions Click Here