Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 6690

what is main functional differences between BO and COGNOs?

TCS,

5 10467

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

iGate,

6 8817




SAS System ?

4 4972

sas macros

12 12885

how to test reports in businessobjects?

TCS,

8 40773

What is source qualifier?

1 4913

Difference between DSS & OLTP?

IBM,

5 29138

Explain grouped cross tab?

1288

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 12447

How many repositories can we create in Informatica?

Informatica,

14 14557

What is surrogate key?

IBM,

5 13463

What is difference between Mapplet and reusable transformation?

UST,

3 2034

What is aggregate awareness?

2 4034

Explain reference cursor?

829







Un-Answered Questions { Data Warehouse }

What is Discrete and Continuous data in Data mining world?

1037


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

799


whats the logic to load the lower level of granularity of data to fact table.

753


actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

426


How can you first report in Business Objects by using broadcast agent?

1625


------------------What is Inline Query?

883


How we can create SAS USER DEFINED CODE?

603


what the mean of version error in crystal?

906


4. How many dimensions did you use in your reports?

632


What is the difference between regular dimension and derminant?

661


Are you involved in writing the inferential analysis plan? Tables specfications?

981


what is the hint? how to use it to reduce the query processing in program?

3709


two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

700


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

502


what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

635