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,

1731

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

Max India,

1 5373

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

 1 2284

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 5019

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

GSK,

1 4817

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 6217

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 8593

what is the use of catalog?

Cognizant,

1 5525

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

Cap Gemini,

1 7841

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 7766

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

 4 23195

what is SAS OPTIMIZATION?

 1817

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

 8 12548

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 4643

How do you add a number to a macro variable?

 2 5231

Un-Answered Questions { Data Warehouse }

For clinical entire study how many tables will create approx?

1520

Explain hybrid slowly changing dimension?

569

How much data hold in one universe.

553

What three things do you consider to be the most important factors for a manager?

596

What is package in BO

2685




What is an i-server?

611

What is informatica? Why do we need it?

643

What are the different servers in sas? : sas-grid-administration

600

What can we do with datastage director?

674

----------------Diff b/w Dimensional modeling and Relational modeling?

13912

What is a dimension table?

610

How to create an external dataset with sas code?

588

What is difference between page break and section report? What is main advantage datawarehousing over oracle?

604

How to implement complex jobs in data stage?

616

What are the functions of a Parser?

610

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