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

wat is report linking in BO..I know that 2 reports can be linked in BO with the help of writing a HTML code .But how. wat s the code.can u give me the example of code taking e fashion as the simple univers data provider.

Accenture,

2 8537

I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?

IBM,

1 5345

filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?

IBM,

2 5002

What is the use of Tree Prompt? Where it is used?Pls give me a real time example?

1 11561

What is the use of Generated Prompt? Where is it used in realtime project?

HCL,

3 15985

Interval Prompt's Usage? Example for usage in Project

Cap Gemini,

2 16054

How can we find out cardinality between two tables?

IBM,

3 10903

what are determinants?

College School Exams Tests, IBM,

4 10801

how to connect the hyperlink in webi reports?

TCS,

7 27671

what is the use of merge option in webi reports? explain with example?

TCS,

2 12231

how to connect one to one report? Explain with example?

TCS,

5 9411

any of the person working on encyclopedia? give the explanation briefly?

TCS,

1 4024

without creating the business view is there possible to create & generate the Crystal reports?

TCS,

3 7018

is it possible to export the webi reports to crystal reports?with out using businessview?

CTC, TCS,

2292

how to hide the prompts?

TCS,

7 11743

Un-Answered Questions { Data Warehouse }

Is it possible to use a client with different version than that of its Informatica server?

1148

What exactly do you know about the typical data analysis?

1108

Explain in detail abt measure objects? And what is the use of it? How to create it?

1016

what are input dataset and output dataset options? : Sas programming

1105

How to manage date conversion in Datastage?

1138

What is looping and how to avoid it in framework manager?

1207

Where we use afc in actuate?

1028

What is expression transformation?

1106

What is a filter transformation and why it is an active one?

970

what is the role of cognos comsultant?what actually it means?pls reply

2326

Can there be sub steps of etl steps?

1030

write a query to retrieve the latest records from the table sorted by version(scd)

1068

How will you do sort in reports in obiee.

842

How to read multiple files using a single datastage job if files have the same metadata?

1252

What are types of partition primary index (ppi) in teradata?

1056

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