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 41392

What is version control in informatica ? Advance thanks

HCL, Puma,

6 18002

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

Puma,

6 10486

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 14544

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

Puma,

1 6441

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

Puma,

1 4473

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

Puma,

4 9580

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

Puma,

2 15722

/* 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 5631

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

Mind Tree,

5 8431

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..

3531

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 10406

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

1 4396

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

Satyam,

2 5749

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

Satyam,

3 20989

Un-Answered Questions { Data Warehouse }

What is type 2 version dimension?

1023

What are the ETL Testing Operations?

1102

In ARRAY processing, what does the DIM function do?

1232

Difference between project merge and object manager?

1071

What is data stream and data adapter is it same are different? Explain?

1033

is there any difference between operational database and data base?if yes what r they?

2121

Start a batches with in a batch?

1034

What does refresh system mean, and what are its distinctive choice?

1278

What is a mapplet/worklet in informatica?

1249

How can we check the version of Teradata that we are using currently?

1114

What a datastage macro?

1104

What is the use of having index on table?

1043

What is etl tool in hadoop?

956

What is catalog and types of catalogs in cagonos and which is better?

1092

How will you do sort in reports in obiee.

891

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