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

what are the limitations of pushdown optimization technique ? Advance thanks

Puma,

3 41209

What is version control in informatica ? Advance thanks

HCL, Puma,

6 17785

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

Puma,

6 10292

Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation

Puma,

1 14430

Can we write to_date(three arguments) ? Will it work ? Advance thanks

Puma,

1 6330

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

Puma,

1 4393

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

Puma,

4 9397

What is the difference between lookup override and souce qualifier override ?

Puma,

2 15601

/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;

Emerio,

1 5528

Hi friends, How many types of dimentions are they ?What are they? Thanks in advance

Mind Tree,

5 8215

i thought to keep fake experience..as a fresher i can't enter..bcos there is a large gap after my graduation..4 years..any person who enter with fake exp describe how to attend the interview process..

3448

can anybody tell me..how to enter with fake exp..wt r all the documents to carry while attending the interview..how to answer that i am working in..

2 10314

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 4298

what is the usage for assigning error=1 in a dataset ?

Satyam,

2 5646

how to capture rejected data by using join stage not for lookup stage. please let me know

Satyam,

3 20863

Un-Answered Questions { Data Warehouse }

Explain the Roles in mstr?

978

Slowly changing dimensions, types and where will you use them

1713

What is dimension modeling?

1088

Explain clustering algorithm?

2278

How to add default rules in transformer?

1223

What are the performance considerations when working with aggregator transformation?

1152

what is sas metadata repository? : Sas-bi

1119

What is the use of datastage director?

1017

What is a transaction control transformation?

1208

What do you mean by static prompt report?

988

What is perform recovery?

1107

Explain the difference between holap and rolap?

981

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

991

Explain the purpose of retain statement.

1054

what is the way of writing a feeder statement when feeding one cube from another?

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