Data Warehouse Interview Questions
Questions Answers Views Company eMail

What are the common features of Redshift?

5

Does Amazon redshift based on concept cluster?

5

When and why we should use Redshift Spectrum?

5

Does redshift support unstructured data?

5

What is the use of Amazon redshift ODBC driver ?

5

What is the use of AWS redshift driver?

5

What are the business intelligent tools to which Redshift can be integrated with?

5

When can we choose the Redshift ?

5

Is redshift can be used with AWS RDS?

5

What’s the use of redshift?

5

What are the benefits of using AWS Redshift?

5

What data formats does Redshift Spectrum support?

5

Is redshift using primary keys for key-value storage?

5

What’s the use AWS redshift cluster Service?

5

Why should we use data ware housing and how can you extract data for analysis with example?

TCS,

637


Un-Answered Questions { Data Warehouse }

How the Bursting happens in same report and how to Print the bursting Report?

1522


what is session partitioning?

1643


Which means the first record should come as last record and last record should come as first record and load into the target file?

695


How can one identify whether mapping is correct or not without connecting session?

1017


Syntax for case when statement?

694






Identifying the bottlenecks in various components of Informatica and resolving them.

1585


Explain what are non-additive facts in detail?

662


How are models actually derived?

1634


how to abort the job its matain duplicates?

2228


Why is data processing considered beneficial?

694


What is AWS Redshift is used for ?

5


Can you explain engine tier in information server?

751


How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

661


What is an i-server?

708


what is degenerate key in oracle ?whare do we use it?

2161