Data Warehouse Interview Questions
Questions Answers Views Company eMail

what do the sas log messages "numeric values have been converted to character" mean? : Sas programming

533

how do you test for missing values? : Sas programming

569

what are sas/access and sas/connect? : Sas programming

539

what are the scrubbing procedures in sas? : Sas programming

815

how do you want missing values handled? : Sas programming

522

how does sas handle missing values in an update? : Sas programming

1 909

for what purpose would you use the retain statement? : Sas programming

571

what is the difference between nodup and nodupkey options? : Sas programming

609

do you need to know if there are any missing values? : Sas programming

538

what do the pad and dim functions do? : Sas programming

554

what do the mod and int function do? What do the pad and dim functions do? : Sas programming

600

how do you debug and test your sas programs? : Sas programming

549

how do the in= variables improve the capability of a merge? : Sas programming

922

what does the run statement do? : Sas programming

544

what is enterprise guide? What is the use of it? : Sas programming

526


Un-Answered Questions { Data Warehouse }

What are the implications?

1175


whats the logic to load the lower level of granularity of data to fact table.

1785


Explain why should you put your data warehouse on a different system than your oltp system?

504


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

565


What is status code in informatica?

570






What is Discover and Execute in XMLA?

1776


Can you define cognos decision stream?

594


hoe to access second value in mapping parameter if it is having more than one value ?????????????

1122


Explain what is the difference between a primary and secondary actor in use case modeling?

649


what do the pad and dim functions do? : Sas programming

554


how do u set partition points in the mapping?

1790


project Steps,hits, Project level HArd things,Solved methods?

1621


Why sorter is an active transformation?

740


Describe an informatica powercenter?

598


Explain hybrid slowly changing dimension?

553