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 |
How to do Integration testing in Informatica?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
in which situations do u go for starflake schema ?
What is galaxy shema
What is data merging, data cleansing and sampling?
What does update strategy mean, and what are the different option of it?
What is Micro Strategy? Why is it used for?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
what is mean by complex business rule ?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is a shortcut and copy in Informatica and how two are different with each other?