What r the type of indexes u generally used in informatica?
Answers were Sorted based on User's Feedback
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 |
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 |
what is the predefined port in dynamic lookup
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
What are junk dimensions?
What does refresh system mean, and what are its distinctive choice?
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
What is difference between a gateway node and worker node?
Explain transaction control transformation in informatica
Under which circumstances, informatica server creates reject files?
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
who to split dimentions into sub dimention
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?