Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 7403

what is main functional differences between BO and COGNOs?

TCS,

5 11137

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

iGate,

6 9678




SAS System ?

5 5959

sas macros

TCS,

12 14557

how to test reports in businessobjects?

TCS,

8 43698

What is source qualifier?

1 5439

Difference between DSS & OLTP?

IBM,

6 32946

Explain grouped cross tab?

1360

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 13343

How many repositories can we create in Informatica?

Informatica,

14 15658

What is surrogate key?

IBM,

5 14834

What is difference between Mapplet and reusable transformation?

UST,

3 2424

What is aggregate awareness?

2 4447

Explain reference cursor?

900







Un-Answered Questions { Data Warehouse }

2. What functional area you worked on.

986


--------------Explain Table of contents?

719


What are different deliverables according to phases?

2090


what is dynamic insert?

741


What are the steps involved in the migration from older version to newer version of Informatica Server?

597


what is diff b/t sorter t/r and agg have the option sorter property...

793


Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

1098


Hi friends please reply what will be the answer to following question in crystal report 1)Difference between the CR8.5 & CR10.5(withing VS2008) in terms of features. 2)Is Hierarchy of grouping features in either CR8.5 or CR10.5. what are its limitation i.e maximum no's can be created. 3)Scenario - If I have a string semicolon separated(1000 in nos) then how to pass it into Record Selection formula or parameter. 4)Scenario - If user want to do dynamic grouping at runtime that to while designing report only 1 group was created and as per user at runtime based on user selection different fields are used to create group. How is it possible. (Is it possible through formula?) 5)what is cascade or dynamic prompting.whether this is a feature of CR8.5 or CR10.5. 6)what to answer for question "How would you start crystal report development" 7)How "set location" is useful & how to implement it. 8)Scenario - At design time report was developed using MS SQL as datasource but at client side they are using Oracle which is having same table name and structure will the report work? If yes what changes are required to do so. 9)when does "Table Not Found" error is generated.

999


hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

573


draw informatica architecture 8.6 ?

2608


Sequence generator, when you move from develoment to production how will you reset

406


how to implement scd2 in datastage 7.5 with lookup stage

3855


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

1927


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

647


Give e an example of..

732