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 2285

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 5021

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 8596

what is the use of catalog?

Cognizant,

1 5525

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

Cap Gemini,

1 7842

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 7768

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 12554

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 5233

Un-Answered Questions { Data Warehouse }

What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1229

How to generate sequence numbers using expression transformation?

641

what is universe null

1991

Explain the ab initio etl tool in high level?

676

What errors and types of errors you faced in Cognos ReportNet?

3484




Can you explain cognos tm1?

5

What are the popular informatica products?

653

Explain Dataware house architecture .how data flow from intial to end?

2124

hi my name is siraj i want to know cognos queriy language

1817

What do you mean by teradata intelliflex?

632

What is difference between symmetric multiprocessing and massive parallel processing?

653

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3289

Explain how many ways you create ports?

613

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

1971

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1556

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