Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 10982

what is main functional differences between BO and COGNOs?

TCS,

5 15032

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

iGate,

6 14585

SAS System ?

5 10582

sas macros

TCS,

12 24475

how to test reports in businessobjects?

TCS,

8 51328

What is source qualifier?

2 8351

Difference between DSS & OLTP?

IBM,

6 48684

Explain grouped cross tab?

2179

Hierarchy of DWH?

Accenture, EDS, IBM, iFlex, TCS,

2 17477

How many repositories can we create in Informatica?

Informatica,

14 24387

What is surrogate key?

IBM, Informatica,

5 20211

What is difference between Mapplet and reusable transformation?

UST,

3 5640

What is aggregate awareness?

2 6577

Explain reference cursor?

1683


Un-Answered Questions { Data Warehouse }

Define pmcmd command?

604


What can be the size of largest dataset in SAS?

698


Why do you need stage variables?

645


what do you mean by data staging area? : Sas-di

587


Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

844






Why did ibm cognos tm1 web change the technology from .net to java?

5


Explain what is the difference between business requirement document and use case document.

563


List out the file extensions used in abinitio?

648


What are the functions which are used for character handling functions?

597


What are the differences between datastage and informatica?

560


Your application mode has crashed. How would you run your i-server?

549


what is information maps?

1592


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

672


Explain what are the various reporting tools in the market?

540


What is the purpose of cluster analysis in data warehousing?

552