Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 6914

what is main functional differences between BO and COGNOs?

TCS,

5 10709

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

iGate,

6 9131




SAS System ?

4 5294

sas macros

12 13355

how to test reports in businessobjects?

TCS,

8 41630

What is source qualifier?

1 5023

Difference between DSS & OLTP?

IBM,

5 30308

Explain grouped cross tab?

1304

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 12679

How many repositories can we create in Informatica?

Informatica,

14 14865

What is surrogate key?

IBM,

5 13809

What is difference between Mapplet and reusable transformation?

UST,

3 2135

What is aggregate awareness?

2 4145

Explain reference cursor?

848







Un-Answered Questions { Data Warehouse }

what are the features in cognos8ui

704


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

731


How to load specific no.of records using bteq, or fastload,or multiload

171


what are the dimensions that you have in your current project?list them?

675


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

877


Can Bo generates the Report from the cubical data Explain?

716


How to create a tooltip in Webi? Is there a way to create Tooltips in Webi reports for non- hyperlinked columns? Users should be able to hover over a value in a column in the report and that should show a tooltip box with more detail regarding that column value. This is possible when you hyperlinked the column,Is it possible when you dn't have hyperlinking? Thanks in advance.

3827


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

435


how tokens will generate?

767


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

704


how can we analyze the locks ?

714


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

1322


can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

825


You can ask about different vector functions. How to use in abinitio graph?

2211


How do you set a varible in incremental aggregation

380