Answer Posted / ande
we have bitmap index, b-tree index, function based index,
reverse key index and composit index. we will use bitmap
index in DWH
Regards,
ande
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the sequence generator transformation in informatica?
If informatica has its scheduler why using third party scheduler?
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?
Explain sessions?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What will be the approach?
What is rank transform?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain dynamic target flat file name generation in informatica
What are roles and groups and benefits of using them?
What are the types of caches in lookup? Explain them.
what is the size of your data warehousing?
Briefly describe lookup transformation?
Enlist some properties of sessions.
What is meant by incremental aggregation?