Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 9033

what is main functional differences between BO and COGNOs?


5 12949

hi Here ive question on Reportnet when we save a report in reportstudio with what ext it save


6 11594

SAS System ?

5 8389

sas macros


12 19084

how to test reports in businessobjects?


8 48270

What is source qualifier?

2 6880

Difference between DSS & OLTP?


6 41331

Explain grouped cross tab?


Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 15158

How many repositories can we create in Informatica?


14 19020

What is surrogate key?

IBM, Informatica,

5 17618

What is difference between Mapplet and reusable transformation?


3 3876

What is aggregate awareness?

2 5413

Explain reference cursor?


Un-Answered Questions { Data Warehouse }

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming


What is the use of powerhouse?


How to Reset Pagenumbers in one report.


how to add a new records into source?


1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance


Can anyone tell me the new features in Informatica 9 Version?


What are pdv and it functions?


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


Name the different lookup cache(s)?


Did you face any problems while creating reports? Name? Solutions?


What is meant by a node?


when will use SQL override in a lookup transformation?


how do u extract data from different data sources explain with an example?


What is Linear Regression?


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?