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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

explain the difference between proc means and proc summary?

 652

Mention the difference between ceil and floor functions in sas?

 629

How to include or exclude specific variables in a data set?

 624

What is substr function?

 607

why a stop statement is needed for the point= option on a set statement?

 614

How can sas program be validated?

 563

Mention how to limit decimal places for the variable using proc means?

 628

What is a put statement?

 651

How to read an input file in sas?

 637

How sas treats the dsd delimiters?

 704

How can you limit the variables written to output dataset in data step?

 733

how to remove duplicates using proc sql?

 620

How to display duplicate observations in data?

 1 917

What are common programming errors committed in sas

 655

What are the difference between ceil and floor functions in sas?

 687

Un-Answered Questions { Data Warehouse }

How to generate the cubes in framework manager?

541

What is a functional dependency f said to be minimal?

532

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1658

What do the SAS log messages "numeric values have been converted to character" mean?

868

What is the difference between datawarehousing and businessintelligence?

599




Have you ever encountered an error called “depth not equal”?

637

How substr function works in sas?

689

How to configure mapping in informatica?

666

How sas treats the dsd delimiters?

704

How can we do data cleaning?

572

What is aggtorec restructure operator?

709

how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?

1857

Define different types of attributes in microstrategy desktop?

754

Define ramp limit in ab initio?

753

How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on

459

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