Data Warehouse Interview Questions
Questions Answers Views Company eMail

How will the AWS redshift work?

5

Is AWS redshift is one of the RDS in AWS or is it Relation Database?

5

What is AWS Redshift is used for ?

5

What Amazon redshift built for ?

5

Why AWS redshift is named after Redshift?

5

What is cluster AWS cloud?

5

Is AWS Redshift a stored procedures?

5

Which is the database redshift is using?

5

What is the difference between s3 and redshift?

5

Why redshift Distribution key is used?

5

Does AWS Redshift use SQL?

5

What kind of application/services uses Redshift database?

5

What is MPP in Redshift ?

5

Is Redshift similar to RDS ?

5

AWS Redshift is basically works on nodes and cluster and which of following option Redshift is based on?

5


Un-Answered Questions { Data Warehouse }

what does the run statement do? : Sas programming

651


What is metadata in context of a datawarehouse and how it is important?

651


In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1627


What is the use of an aggregator cache file?

776


Do you need to rearrange the order of the data for the report?

1934






Explain Teradata performance tuning and optimization?

803


what is proc Index? and what is proc document?

2073


What is meta data and system catalog?

1939


What are the different types of schemas used in data warehousing?

595


Mention few advantages of router transformation over filter transformation.

736


How to select first n records in teradata?

692


what is index?how it can work in informatica

1695


Clarify the aggregator change?

687


Can you implement SCD2 using join, transformer and funnel stage?

1189


what is the project environment(for each project the environment is same or different to different project)?

1756