What r the type of indexes u generally used in informatica?
- 2 Answers
- 18410 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 lookup cache(s)?
Using Expression transformation how to remove duplicate records from a relational source?
How will u pas the data with out debugger?
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
why union transformation is active transformation?
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
Explain what are the different versions of informatica?
what is junk dimension
In which transformation you cannot drag ports into it?
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
Teradata 
