1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

What are cubes and olap cubes?

 660

What are the three tiers in etl?

 681

What are dimensions?

 669

What are the steps involved in etl process?

 598

What is initial load and what is full load?

 593

Explain different types of partitioning?

 692

List few etl bugs?

 609

What are three tier systems in etl?

 707

What are your responsibilities as an etl tester?

 719

What is grain of fact?

 613

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

 627

What do you understand by the term ‘transformation’?

 614

Explain the key challenges that you face while performing etl testing.

 652

Mention few test cases and explain them?

 627

Explain etl mapping sheets?

 748

Un-Answered Questions { Data Warehouse }

Different circumstance which drives informatica server to expel records?

634

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

1752

Why denormalization is promoted in universe designing?

649

where to store informatica rejected data?

766

What are the steps to do to use alerts in bo?

705




Your application mode has crashed. How would you run your i-server?

629

Describe primary index in teradata. And what are the available primary index types?

630

Define report item?

764

Suppose we do not group by on any ports of the aggregator what will be the output?

681

I'm busy writing a report that's using report bursting, to be able to do this I need to use a sequential section. Using a sequential section cause the grouping of the original report not to work. Please can someone give me advise on how to come past this problem, the report need to use grouping as it depend largely on totals ect, and I need to use a sequential section within the report to be able to use the report bursting facility.

2455

What is the maximum and minimum length of macro variable

758

How rejected rows are managed in datastage?

1030

Explain what is the data type of the surrogate key?

657

What are the functions performed by bynet?

706

What is dimensional table? Explain the different dimensions.

767

For More Un-Answered { Data Warehouse } Questions Click Here