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 Proc glm does?

1154

What is the use of PROC gplot?

1220

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

1212

What is the difference between INPUT and INFILE ?

1397

What is Linear Regression?

1232

What is interleaving in SAS?

1183

What is SAS informats?

1169

What does P-value signify about the statistical data?

1409

List out some key concept of SAS

1223

Describe the ways in which you can create macro variables?

1267

What is the use of function Proc summary?

1353

Difference between sum function and using “+” operator?

1216

What is PDV?

1213

What are the new features included in the new version of SAS Programming Language?

1254

What is SAS? What are the functions does it performs?

1254

Un-Answered Questions { Data Warehouse }

What are the various reporting tools in the market?

1127

How do you convert basic cube to transaction cube and transaction cube to basic cube?

2290

What is an unconnected transformation?

1143

What is the purpose of upsert command?

1279

What a local lookup is?

1123

Is it possible to use microstrategy object manager while other users are making changes in microstrategy agent?

998

What is catalog and types of catalogs in cagonos and which is better?

1095

46.How you can create cross joined output using join component ? 47.What is the default layout of watcher files ? How to use in abinitio graph? 48.Why you get 'too many open files' error ? How to use in abinitio graph? 49.What is the significance of vnode folder under AB_WORK_DIR ? How to use in abinitio graph? 50, What is the significance AB_AIR_BRANCH? How to use in abinitio graph? 51. How can you select only unique records from a set of records ? How to use in abinitio graph? 52. How next_in_sequence work in parallel layout ? How to use in abinitio graph? 53. Why you want to set a modest number in limit ? How to use in abinitio graph? 54. How you can encrypt a password and use it in dbc file? How to use in abinitio graph? 55. Which function you should be using if you do not want to process non printable char from a feed file ? How to use in abinitio graph? 56. How you can run a component for certain conditions ? How to use in abinitio graph? 56. What is catalog and when you should use it ? How to use in abinitio graph? 57. How you can use reformat as a router ? How to use in abinitio graph? 58. How many process gets created for a n-way parallel component ? How to use in abinitio graph? 59. Why delimited DMLs take more time to process than fixed length DMLs? How to use in abinitio graph? 60. How can you select only first and last record from a file without using next_in_sequence? How to use in abinitio graph? 61.Why you should always keep largest input as driving input for Join ? How to use in abinitio graph? 62. What a catalog file contains ? How to use in abinitio graph? 63. What Is private project and public project ? How to use in abinitio graph? 64. Why you should not use checkpoint after replicate ? How

5810

How to elaborate powercenter integration service?

1178

Your i-sever crashed. What will you do?

1118

What is mean by aggregate aware?

1174

what is Forward,Reverse and Re_engineering?

2292

how to remove duplicates using proc sql?

1208

What is the syntax for m_dump in abinitio?

1686

What is data stream and data adapter is it same are different? Explain?

1038

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