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 testing in a mapping level please give brif eplanation

CTS,

1 8012

what is upstream and downstream transformation?

7 35942

how data modeling is usefull to cognos?

1 5311

can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?

1 12512

what is physical layer and presentation layer?

Zensar,

2 13138

pls any body give the cognos 8 versions release year.

3 6714

how do we apply sql query on selected variables?

3 7046

am a fresher hw to get real time experience?

Cap Gemini,

1 6409

how can we overcome by loops?and also is it possible ,one user can different universe

4 7514

what is the difference between the active datawarehouse and datawarehouse

TCS,

1 14920

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

Accenture,

3 14724

how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

Accenture,

6 20751

Can you please tell me the limitation of Excel file when exporting from report to Excel? I can export to HTML and PDF but I can't export to Excel. The report is more than 13000 rows. When exporting to Excel, system can view it. After that, I save the report to an Excel file. The size of Excel file is more than 11 MB. But I can't view this file by Excel. Please help me to solve this problem. Thanks!

1 7969

what is custom sorting?how we can do this expalain with procedure???

Keane India Ltd,

2 9900

how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how

Keane India Ltd,

3 8015

Un-Answered Questions { Data Warehouse }

What is the maximum length of the macro variable?

1198

What are the new features of informatica 9.x developer?

982

Describe the architecture of datastage?

1026

what is the cube size?

What are differences between teradata and ansi session modes in teradata?

1182

What are the different type of jobs in datastage?

1049

What is flashback table ? Advance thanks

1958

What would you consider as your biggest achievement and why?

1025

What information is provided by .dbc file extension for connecting to the database?

1183

How can repository reports be accessed without sql or other transformations?

1235

Why did ibm cognos tm1 web change the technology from .net to java?

Explain teradata utilities. What is multiload, fast load, tpump?

1020

What is data warehouse architecture?

1056

What are symget and symput? : sas-macro

1328

How does the aggregator transformation handle null values?

1157

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