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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

what is hash files in sas and why we are using this one in sas?

L&T, SAS,

1722

what is validvarname and varnum? why we are using this options; explain with a syntax for this options?

Max India,

1 5361

i want to upload titles and footnotes to excel file?how it is possible?

 1 2277

i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?

 3 4997

i have a dataset with var1,var2,var3; i want to upload the titles for the variables . How can we?

GSK,

1 4807

i have a null dataset with 20 variables. i want to upload the variables which contain name like a or k or anything in another dataset.how can we create the dataset?

L&T,

3 6200

i have 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?

GSK,

6 8561

what is the use of catalog?

Cognizant,

1 5514

How to eliminate duplicate records in informatica mapping? Explain with an example....

Cap Gemini,

1 7832

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

Cap Gemini,

3 7749

Using Expression transformation how to remove duplicate records from a relational source?

 4 23179

what is SAS OPTIMIZATION?

 1813

In PROC PRINT, can you print only variables that begin with the letter “A”?

 8 12508

Could you please answers for this. 1.Code the tables statement for a single-level (most common) frequency. 2.Code the tables statement to produce a multi-level frequency.

 2 4627

How do you add a number to a macro variable?

 2 5228

Un-Answered Questions { Data Warehouse }

Which transformation we use to convert 'NA' to 'Not Available'

849

What are the table names in oracle database...?

2246

Who needs data warehousing?

552

What is virtual Data Warehousing?

544

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

832




What is a cursor? Within a cursor, how would you update fields on the row just fetched?

652

What are data modeling and data mining? Where it will be used?

541

explain about dirty dimension?

631

Sequence generator, when you move from develoment to production how will you reset

1398

Tell me what is degree of a relation?

516

What is joiner transformation in informatica?

623

How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1092

Explain what is aggregate table and aggregate fact table ... Any examples of both?

603

Difference between Target-based loading and constraint-based loading?

548

explain the concepts and capabilities of business object? : Sas-bi

536

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