Interested to Buy Any Domain ? << Click Here >> for more details...
What r the type of indexes u generally used in informatica?
- 2 Answers
- 18973 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
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 are the different types of schemas?
Define maping and sessions?
how can we check whether a particular cache is static or dynamic?
checkout and checkin in informatica 8.6
what is the difference between Informatica7.1 & informatica 8.1
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
What is the use of transformation?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
What are the new features of informatica 9.x developer?
Teradata 
