Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 7564

what is main functional differences between BO and COGNOs?

TCS,

5 11312

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

iGate,

6 9886




SAS System ?

5 6202

sas macros

TCS,

12 14918

how to test reports in businessobjects?

TCS,

8 44225

What is source qualifier?

1 5598

Difference between DSS & OLTP?

IBM,

6 33869

Explain grouped cross tab?

1394

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 13528

How many repositories can we create in Informatica?

Informatica,

14 15931

What is surrogate key?

IBM,

5 15266

What is difference between Mapplet and reusable transformation?

UST,

3 2537

What is aggregate awareness?

2 4527

Explain reference cursor?

942









Un-Answered Questions { Data Warehouse }

Describe what the SQL Server tempdb and tlog files are used for?

931


hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

900


where is the reject loader .

429


h0w many versions have been developed of onformatica so far?

887


give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

1122






what is the procedure for scheduling conditional rendering?

1114


Two default user groups created in the repository are____and_____.

887


I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

842


What are the issues you have faced in your project? How did you overcome those issues?

1063


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

164


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

952


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

1000


design of staging area?

697


how to connect to a flatfile through ftp in informatica

11371


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

1089