Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 6298

what is main functional differences between BO and COGNOs?

TCS,

4 10113

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

iGate,

6 8390




SAS System ?

4 4590

sas macros

12 12360

how to test reports in businessobjects?

TCS,

8 39583

What is source qualifier?

1 4751

Difference between DSS & OLTP?

IBM,

5 27992

Explain grouped cross tab?

1254

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 12139

How many repositories can we create in Informatica?

Informatica,

14 14055

What is surrogate key?

IBM,

5 13102

What is difference between Mapplet and reusable transformation?

UST,

3 1844

What is aggregate awareness?

2 3851

Explain reference cursor?

793







Un-Answered Questions { Data Warehouse }

If money were no object, what would you like to do?

1346


what is a prompt value in report studio and variables ?

1231


Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

394


HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

2585


How to test a cube?

691


Did u used latest transformations of 8.6.0? for what?

429


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

6755


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

1330


how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

603


Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

671


Can we use target hash file as a lookup ?

1025


what is the use of catlog or catlogfile?

697


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

136


what is the difference between informatica6.1 and infomatica7.1

550


Can we configure two instances of CMS pointing to two different CMS system databases?

579