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?


5 10709

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


6 9131

SAS System ?

4 5294

sas macros

12 13355

how to test reports in businessobjects?


8 41630

What is source qualifier?

1 5023

Difference between DSS & OLTP?


5 30308

Explain grouped cross tab?


Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 12679

How many repositories can we create in Informatica?


14 14865

What is surrogate key?


5 13809

What is difference between Mapplet and reusable transformation?


3 2135

What is aggregate awareness?

2 4145

Explain reference cursor?


Un-Answered Questions { Data Warehouse }

what are the features in cognos8ui


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?


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


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


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.


Can Bo generates the Report from the cubical data Explain?


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.


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 .


how tokens will generate?


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


how can we analyze the locks ?


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?


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 much time u will take to complete one project,single person in a team have to do how many a real time how much time will take to complete reports single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible mail- id is


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


How do you set a varible in incremental aggregation