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 8016

what is upstream and downstream transformation?

7 35964

how data modeling is usefull to cognos?

1 5315

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

1 12520

what is physical layer and presentation layer?

Zensar,

2 13144

pls any body give the cognos 8 versions release year.

3 6716

how do we apply sql query on selected variables?

3 7066

am a fresher hw to get real time experience?

Cap Gemini,

1 6415

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

4 7521

what is the difference between the active datawarehouse and datawarehouse

TCS,

1 14924

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

Accenture,

3 14734

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 20762

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 7974

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

Keane India Ltd,

2 9910

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 8025

Un-Answered Questions { Data Warehouse }

What are aggregate transformation?

1048

What are different table types used in teradata?

1062

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1300

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

998

is cognos 7 is better than cognos 8

2178

What is the ab initio business rules environment (bre)?

1186

Explain what is cost benefit analysis (cba)?

983

What is Linear Regression?

1184

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

2015

When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?

2452

How would you determine the number of missing or nonmissing values in computations?

1086

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

1013

what is the difference between the report filter and report limit?

980

How can you track login parameters of users in teradata?

1207

What are shortcuts? Where it can be used? What are the advantages?

1090

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