What is the commit type if you have a transaction control transformation in the mapping?
Give me any example of semi and non additive measures?
Give some difference between oltp and olap.
What are the various indexes in teradata? How to use them?
Why is business intelligence (bi) important in data warehousing?
What are the different lookup cache(s)?
How to use consolidations in microstrategy report?
Explain what are fact, dimension, and measure?
Discuss the advantages of using partitioned primary index in a query?
What’s the difference between var b1 – b3 and var b1 — b3?
What are the difficulties u faced while doing vital signs table or dataset?
What are roles and groups and benefits of using them?
How to load specific no.of records using bteq, or fastload,or multiload
What is the purpose of having stored procedures in a data-based?
What is prompt types of prompts?use of prompts syntax of prompt?