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 41220

What is version control in informatica ? Advance thanks

HCL, Puma,

6 17801

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

Puma,

6 10310

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 14434

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

Puma,

1 6340

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

Puma,

1 4398

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

Puma,

4 9409

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

Puma,

2 15606

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

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

Mind Tree,

5 8226

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

3451

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 10320

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

1 4304

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

Satyam,

2 5651

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

Satyam,

3 20871

Un-Answered Questions { Data Warehouse }

explain the use of % includes a statement in sas? : Sas-administrator

1008

Can you state some of the innovations throughout history?

986

How can informatica be used for an organization?

1221

What is an error log table in informatica occurs and how to maintain it in mapping?

969

Explain is olap databases are called decision support system true/false?

1010

What is the difference between teradata and oracle?

1033

What are the steps involved after the disk manager passes the request?

1123

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4376

How to use consolidations in microstrategy report?

1046

Explain the main difference between the sas procedures and functions? : Sas-administrator

1080

Why does varchar occupy 2 extra bytes?

1201

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2367

What is a three-tier data warehouse?

1120

Hi friends please reply what will be the answer to following question in crystal report 1)Difference between the CR8.5 & CR10.5(withing VS2008) in terms of features. 2)Is Hierarchy of grouping features in either CR8.5 or CR10.5. what are its limitation i.e maximum no's can be created. 3)Scenario - If I have a string semicolon separated(1000 in nos) then how to pass it into Record Selection formula or parameter. 4)Scenario - If user want to do dynamic grouping at runtime that to while designing report only 1 group was created and as per user at runtime based on user selection different fields are used to create group. How is it possible. (Is it possible through formula?) 5)what is cascade or dynamic prompting.whether this is a feature of CR8.5 or CR10.5. 6)what to answer for question "How would you start crystal report development" 7)How "set location" is useful & how to implement it. 8)Scenario - At design time report was developed using MS SQL as datasource but at client side they are using Oracle which is having same table name and structure will the report work? If yes what changes are required to do so. 9)when does "Table Not Found" error is generated.

2188

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2582

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