What r the type of indexes u generally used in informatica?
Answer Posted / 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 View All Answers
Explain where to store informatica rejected data? How to extract the informatica rejected data?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain the etl program with few examples.
What is the need of an ETL tool?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How does the aggregator transformation handle null values?
What does cheating measurement mean?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How can we use mapping variables in informatica? Where do we use them?
write a query to retrieve the latest records from the table sorted by version(scd)
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is dimensional table? Explain the different dimensions.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?