Data Warehouse Interview Questions
Questions Answers Views Company eMail

how you can enable bulk load mode in ti?

IBM,

5

how many types of viewers available in tm1?

IBM,

5

define cognos connection?

IBM,

5

define under feeding?

IBM,

5

define over feeding?

IBM,

5

define the logic behind the sparsity in cubes?

IBM,

5

how many users can open or connect to one of the tm1 web application concurrently?

IBM,

5

name the prompt which are available in cognos?

IBM,

5

Define bulk load mode?

IBM,

5

name the data sources which are available with ti?

IBM,

5

how to run turbo integrator process from command line?

IBM,

5

define sparse cube?

IBM,

5

how does rules tracer help us?

IBM,

5

name the function which is used to serialize the ti process?

IBM,

5

what are the steps to troubleshoot the feeders?

IBM,

5


Un-Answered Questions { Data Warehouse }

What is primary index and secondary index?

655


How are the dimension tables designed?

650


Name any two sas spawners? : sas-grid-administration

657


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1397


What sort of existing documents should business analysts refer to when starting on a new project?

694






Design a mapping to load a target table with the following values from the above source?

975


Explain the informatica workflow?

694


How to create Target definition for flat files?

867


How a server job can be converted to a parallel job?

716


What is the syntax for case when statement?

678


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7798


What's the layout of parameter file (what does a parameter file contain?)?

2033


What is the difference between the content store and content manager?

649


Explain informatica architecture - version 8 / 9

757


How create measures and dimensions?

691