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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

what is sas data set?

 664

How will you generate test data with no input data?

 561

What is the difference between input and infile statement?

 678

What is the difference between reading data from an external file and reading data from an existing data set?

 632

Describe the ways in which you can create a macro variable?

 621

Mention the category in which sas informats are placed?

 624

How substr function works in sas?

 699

What is the difference between informat and format statement?

 1 924

How do dates work in sas?

 639

What is the difference between the proc sql and data step?

 659

What is the good sas programming practices for processing large data sets?

 624

What is the difference between where and if statement?

 615

What are the different types of sas functions?

 603

Mention common programming errors committed in sas ?

 644

What is by-group processing?

 572

Un-Answered Questions { Data Warehouse }

What are the design methods of data warehousing?

511

What does the RUN statement do?

847

What formatting can be applied to the information that is sent out by microstrategy narrowcast server?

562

What are the types of partitioning?

570

Quickly characterize reusable change?

687




Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1615

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

1743

Can you fastexport a field, which is primary key by putting equality on that key?

707

Can you define materialized view?

617

What are the steps involved in the migration from older version to newer version of Informatica Server?

1573

Where the applications and where ware house management system is used?

534

How will the document be delivered to me?

611

What are the message flows?

555

What is drill-through?

572

Which transformation is needed while using the Cobol sources as source definitions?

724

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