Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 6532

what is main functional differences between BO and COGNOs?

TCS,

5 10298

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

iGate,

6 8606




SAS System ?

4 4821

sas macros

12 12636

how to test reports in businessobjects?

TCS,

8 40281

What is source qualifier?

1 4853

Difference between DSS & OLTP?

IBM,

5 28611

Explain grouped cross tab?

1275

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 12327

How many repositories can we create in Informatica?

Informatica,

14 14336

What is surrogate key?

IBM,

5 13311

What is difference between Mapplet and reusable transformation?

UST,

3 1946

What is aggregate awareness?

2 3948

Explain reference cursor?

817







Un-Answered Questions { Data Warehouse }

------------- How to identify the Revenue Column in Report?

750


Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

450


1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

1916


whats the difference between previous version of cognos and cognos 8 BI?

3304


Tell e how how dealt with..

744


what are the reporting tools and difference between them?

711


for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

654


In which scenario did you used pushdown optimization?

684


How we can create SAS USER DEFINED CODE?

586


I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

298


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

925


Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

2356


how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

1001


How to do Performence Tunning in Cognos Reports?

1134


Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

492