Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

Can any one please provide me practical example of How to do the performance tuning in Query??

Amdocs,

5 11657

Why FLOAD does not support multiset tables??

TCS, Tesco,

3 14051

What is collect State in Teradata ? what it use and how it works??

TCS,

3 12937

What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .

Accenture,

5 34279

What is the order of evaluation of the comparison && logical && relational operators:?

CitiGroup,

2 6513

proc means? proc sort? proc append? proc freq? proc print? proc content?

Oracle,

4 12787

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

TCS,

6 12903

how to handle null values in sequential file?

HCL,

1 19632

how to handle null values using transformer stage?

1 7773

how can u handle null values in transformer stage.

7 27990

Disply the dname wise maximum salary

Principal Finance,

9 11828

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

IBM,

1 6177

I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 3771

How to use Normalizer transformation?

2 5427

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

Accenture, CSC,

3 15216

Un-Answered Questions { Data Warehouse }

Explain adhoc reports?

943

What is type 2 version dimension?

975

Define datastores in cognos?

953

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1032

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2126

What according to you might be the future of data warehousing?

1027

Does redshift support unstructured data?

Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

1029

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3842

what is the use of proc sql? : Sas programming

1133

Explain what are the possible data marts in retail sales?

1011

Explain 4gt switch. Does it have any drawback?

969

1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

3568

What could be the possible resons of locks by user?

1094

Explain fact table?

1057

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