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

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

Cap Gemini,

6 14388

please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

2144

1)How to Duplicate Records Delete in Sequential file?

IBM, TCS,

4 15403

can we join volatile table with general table an global temporary table with general table ?

IBM,

4 10357

how to restrict up to three levels in hierarchy when u do drill mode?

iGate,

3 8397

what are the tables used in health care domain project and columns used in report?

IBM,

4559

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1841

if we shortcut join between two tables what will be the output?that it will give all columns or same columns?

2 5457

In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;

1 7295

How is Teradata in current market?

4 8987

What are the issues you have faced in your project? How did you overcome those issues?

CTS, FEEE, TCS,

2418

How to create a report template BO XI R2

Infosys, LBM,

2 9321

From where you extract the data, how you did it into informatica? explain....

Accenture, Unisoft Infotech,

1 6179

What are your source in project and how you import in informatica? How can i explain abt this?

Accenture, Unisoft Infotech,

1 6575

What are events in workflow manager?

Accenture, IBM,

1 8886

Un-Answered Questions { Data Warehouse }

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1190

What is the difference between a scan component and a rollup component?

1239

What do you know about partition and also tell us about partition components in abinitio?

1108

Can anybody tell me what are the tuning problems?

2098

Define report item?

1254

Is it possible to define a single node as a Gateway node as well as worker node?

1188

What are the limitations for memory allocation for SAS variables

1553

Is it possible to get a floating window in microstartegy web? If yes, how?

1213

What is a dw? Why do we need it?

1030

How to delete data which is not in source table?

1396

what are some differences between proc summary and proc means? : Sas programming

1201

how to load rows into fact table in data warehouse

1235

what is the meaning of upgradation of Repository?

3801

What is a bo repository?

1110

What is spool space? Why do you get spool space errors?

1088

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