Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 11011

what is main functional differences between BO and COGNOs?

TCS,

5 15063

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

iGate,

6 14598

SAS System ?

5 10589

sas macros

TCS,

12 24495

how to test reports in businessobjects?

TCS,

8 51379

What is source qualifier?

2 8364

Difference between DSS & OLTP?

IBM,

6 48702

Explain grouped cross tab?

2181

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 17485

How many repositories can we create in Informatica?

Informatica,

14 24412

What is surrogate key?

IBM, Informatica,

5 20223

What is difference between Mapplet and reusable transformation?

UST,

3 5652

What is aggregate awareness?

2 6585

Explain reference cursor?

1687


Un-Answered Questions { Data Warehouse }

what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

541


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1661


Do you know how to prioritize the excecution of a report?

542


if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

931


What are the enhanced features in teradata v2r5 and v2r6?

680






what are factless facts? And in which scenario will you use such kinds of fact tables.

1301


Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2296


Do you need to rearrange the order of the data for the report?

1825


What are the tracing options available in microstrategy object manager?

565


Your application mode has crashed. How would you get the instance back?

520


How do you convert basic cube to transaction cube and transaction cube to basic cube?

1759


client know skid info?

1625


What happens when we provide null key to sort, merge and pbks in Abinitio ?

808


Explain the types of lookup transformation?

553


What are the functionalities of link partitioner?

608