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 14178

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

2101

1)How to Duplicate Records Delete in Sequential file?

IBM, TCS,

4 15192

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

IBM,

4 10188

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

iGate,

3 8240

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

IBM,

4512

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

1771

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

2 5355

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 7207

How is Teradata in current market?

4 8835

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

CTS, FEEE, TCS,

2363

How to create a report template BO XI R2

Infosys, LBM,

2 9179

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

Accenture, Unisoft Infotech,

1 6091

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

Accenture, Unisoft Infotech,

1 6497

What are events in workflow manager?

Accenture, IBM,

1 8827

Un-Answered Questions { Data Warehouse }

plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........

2353

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1920

Can we Save (save as) WEBI Doc as DESKI?

8176

What are the steps needed to create a simple basic datastage job?

1235

name the data sources which are available with ti?

What are the popular informatica products?

1010

What are the steps to do to use alerts in bo?

1394

Explain the term 'tables' related to relational database management system?

1047

Mention the difference between ‘macros’ and ‘prompt’?

1147

What is meant by a node?

1041

What is the difference between set functions and filter function in dimensional data?

2910

What is deployment group?

1213

How can we improve session performance in aggregator transformation?

1117

What is substr function?

1188

What do you understand by SOA of Informatica?

989

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