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 8126

what is upstream and downstream transformation?

7 36260

how data modeling is usefull to cognos?

1 5394

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

1 12627

what is physical layer and presentation layer?

Zensar,

2 13261

pls any body give the cognos 8 versions release year.

3 6870

how do we apply sql query on selected variables?

3 7244

am a fresher hw to get real time experience?

Cap Gemini,

1 6488

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

4 7684

what is the difference between the active datawarehouse and datawarehouse

TCS,

1 15037

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

Accenture,

3 14893

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 21032

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 8086

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

Keane India Ltd,

2 10016

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 8211

Un-Answered Questions { Data Warehouse }

Demonstrate experience in maintaining quality process standards?

2675

Have you have ever worked in unix environment and why it is useful in datastage?

1217

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

847

how to generate the test data in sas without input data? : Sas-administrator

1207

How would you format some text using css to be verdana and bold?

1150

What is node? How many nodes and amps used in your previous project?

1178

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2334

how many reports have u created ? explain a few.

2162

Write the unconnected lookup syntax?

1152

explain in detail about type 3?

1091

Are you involved in writing the inferential analysis plan? Tables specifications?

4019

Explain how to generate iqd file from framework manager?

1022

What is rollup component?

1337

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2176

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2494

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