Data Warehouse Interview Questions
Questions Answers Views Company eMail

define feeders?

IBM,

5

what is the way of writing a feeder statement when feeding one cube from another?

IBM,

5

what is the meaning of ending bulk load mode?

IBM,

5

name the different procedures within ti?

IBM,

5

define snapshot?

IBM,

5

what is the difference between list and crosstab?

IBM,

5

what is the limit of string length in turbo integrator?

IBM,

5

define junk dimension?

IBM,

5

differentiate between power play transformer and power play reports?

IBM,

5

how do you use tm1 cubes in framework manager?

IBM,

5

define query subject?

IBM,

5

define data tab?

IBM,

5

what actually happens when bulk load mode starts?

IBM,

5

what are the basic features of cognos tm1?

IBM,

5

define prolog tab?

IBM,

5


Un-Answered Questions { Data Warehouse }

How can we load the time dimension?

789


Explain what are the steps to do to use alerts in bo?

701


Do we need an etl tool?

632


how would you determine the number of missing or nonmissing values in computations? : Sas programming

774


List out some key concept of SAS

701






Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1708


what is sas metadata repository? : Sas-bi

705


According to his methodology what all you need before you build a datawarehouse

1288


how can we create rank using datastage?what is the meaning of rank?

8298


How do you debug and test your SAS programs?

1140


How can we improve performance of data stage jobs?

696


What is the function you would use to transfer a string into a decimal?

827


What are public objects?

710


What is report as filter in microstrategy?

610


In ARRAY processing, what does the DIM function do?

806