On the fact table it is best to use bitmap indexes. Dimension tables can use bitmap and/or the other types of clustered/non-clustered, unique/non-unique indexes.
To my knowledge, SQLServer does not support bitmap indexes. Only Oracle supports bitmaps.
Explain What is the limit to the number of sources and targets you can have in a mapping?
Explain What are the tasks that Loadmanger process will do?
Explain What is batch and describe about types of batches?
How to do unit testing in informatica? How to load data in informatica ?
Explain What are the mapping paramaters and maping variables?
Why we use repository connectivity?
Explain the Differences between Normalizer and Normalizer transformation?
How to handle decimal places while importing a flatfile into informatica?
What is the difference between Informatica 7.0 and 8.0?
Explain Where to store informatica rejected data? How to extract the informatica rejected data?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
