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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

 778

What is difference between primary key and unique key constraints?

 709

Define query items?

 743

What are the different uses of a repository manager?

 738

Define dimensions?

 764

Why need staging area database for dwh?

 789

What are shortcuts? Where it can be used? What are the advantages?

 688

Give the advantages of cognos?

 727

Name the types of gateway?

 723

Explain the characteristics of cognos?

 736

Name the types of report?

 688

What are the advantages of shortcuts?

 669

Define olap designer?

 850

Define report item?

 817

Can you define drill across?

 693

Un-Answered Questions { Data Warehouse }

What are normalization, first normal form, second normal form and third normal form?

789

What is metadata in microstrategy?

740

How are the sources and targets definitions imported in informatica designer?

827

What is the basic structure of a sas program?

738

How do you determine the number of sessions?

763




What are the limitations of amazon redshift?

1

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

1981

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3553

What are various etl tools in the market?

656

What metadata importer can do in ab initio?

877

Why redshift Distribution key is used?

5

What are the commands to make a new table, change a table and remove a table in teradata?

792

Explain what is data validation strategies for data mart validation after loading process?

745

Differentiate between proc means and proc summary.

738

What are the ETL Testing Operations?

760

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