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?

TCS,

5 12949

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

iGate,

6 11594

SAS System ?

5 8389

sas macros

TCS,

12 19084

how to test reports in businessobjects?

TCS,

8 48270

What is source qualifier?

2 6880

Difference between DSS & OLTP?

IBM,

6 41331

Explain grouped cross tab?

1731

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 15158

How many repositories can we create in Informatica?

Informatica,

14 19020

What is surrogate key?

IBM, Informatica,

5 17618

What is difference between Mapplet and reusable transformation?

UST,

3 3876

What is aggregate awareness?

2 5413

Explain reference cursor?

1278







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

128


What is the use of powerhouse?

154


How to Reset Pagenumbers in one report.

1634


how to add a new records into source?

1070


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

3268






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

1083


What are pdv and it functions?

142


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

139


Name the different lookup cache(s)?

123


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

2802


What is meant by a node?

140


when will use SQL override in a lookup transformation?

1522


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

1341


What is Linear Regression?

149


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

141