1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

what is an ETL or ETT? And what are the different types?

 6924

how do u extract data from different data sources explain with an example?

 1774

what are the reporting tools and difference between them?

 1585

how do u automate Extraction process?

 1 4000

without using ETL tool can u prepare a Data warehousing and maintaining?

 3 7091

how do u identify the changed records in operational data?

QualTech,

2135

what is SMP AND MPP?

 8 61490

what are the facilities provided by data warehouse to analytical users?

 1669

what are the facilities provided by OLAP to analytical users?

 1 4062

what is HISTOGRAM? how to generate statistics?

 1 4189

how do u set the size of block buffer?

 1 3747

how do u implement unconn.stored proc. in a mapping?

 1 4150

if u can't find what you are looking for in lookup table, how do you handle?

 1 4625

why oracle is the best database for data warehousing?

HCL,

4 7452

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

 1674

Un-Answered Questions { Data Warehouse }

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

836

What is drilling across?

557

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

513

What is "fatal error/rdbms code 3996" error?

663

What is a data profile?

571




Explain how to get the first 100 rows from the flat file into the target?

520

What are the difference between sas functions and procedures?

636

Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

1343

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

572

Explain the teradata primary index mechanics in detail with a diagram.

563

What is core dimension?

548

How can the user determine the object id of an object?

518

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

502

What are the 3 components in sas programming?

723

What do you know about abinitio?

758

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