Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 8260

what is main functional differences between BO and COGNOs?

TCS,

5 12078

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

iGate,

6 10676




SAS System ?

5 7158

sas macros

TCS,

12 16639

how to test reports in businessobjects?

TCS,

8 46356

What is source qualifier?

2 6255

Difference between DSS & OLTP?

IBM,

6 37712

Explain grouped cross tab?

1541

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 14345

How many repositories can we create in Informatica?

Informatica,

14 17113

What is surrogate key?

IBM,

5 16353

What is difference between Mapplet and reusable transformation?

UST,

3 3107

What is aggregate awareness?

2 4914

Explain reference cursor?

1084







Un-Answered Questions { Data Warehouse }

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

5143


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1138


what is use of SDR function?

3695


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

952


my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

1029






In Which Transformation We Can Use Having Clause In Informatica?

173


root tree will find which is server job and which is parallel job?

791


how get the grand total in master-detail report?

1119


what are the others of "bad files" and "discard files" when using sql*loader?

1000


Difference between flat files and relational sources?

1092


we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacity of 60000 record.. how you going to display?

488


How do you test for missing values?

310


how do you manage the production space. what are the proactive methods you can take ?

833


i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

1495


1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

2424