Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 7470

what is main functional differences between BO and COGNOs?

TCS,

5 11212

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

iGate,

6 9760




SAS System ?

5 6027

sas macros

TCS,

12 14662

how to test reports in businessobjects?

TCS,

8 43894

What is source qualifier?

1 5502

Difference between DSS & OLTP?

IBM,

6 33285

Explain grouped cross tab?

1370

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 13403

How many repositories can we create in Informatica?

Informatica,

14 15752

What is surrogate key?

IBM,

5 14965

What is difference between Mapplet and reusable transformation?

UST,

3 2465

What is aggregate awareness?

2 4479

Explain reference cursor?

914







Un-Answered Questions { Data Warehouse }

What are active transformations.

313


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

656


What is Analysis Services?

876


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

785


Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

633


--------------Diff b/w ODS and OLAP?

1854


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.

928


what do u do when DB time takes more?in sap bi

977


What are _numeric_ and _character_ and what do they do?

65


what is different between sequential batch and concurrent batch and which is recommended and why?

3319


what is INFORMATICA TESTING process

854


Define Dynamic push down optmization?

1077


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

550


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

789


What are the modules in Power Center

399