Data Warehouse Interview Questions
Questions Answers Views Company eMail

can BO generate reports with out CUBICAL data to repository?

4 7999

what is main functional differences between BO and COGNOs?

TCS,

5 11742

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

iGate,

6 10368




SAS System ?

5 6780

sas macros

TCS,

12 15992

how to test reports in businessobjects?

TCS,

8 45626

What is source qualifier?

2 5976

Difference between DSS & OLTP?

IBM,

6 36308

Explain grouped cross tab?

1486

Hierarchy of DWH?

Accenture, iFlex, IBM, EDS, TCS,

2 13980

How many repositories can we create in Informatica?

Informatica,

14 16652

What is surrogate key?

IBM,

5 15888

What is difference between Mapplet and reusable transformation?

UST,

3 2863

What is aggregate awareness?

2 4740

Explain reference cursor?

1015







Un-Answered Questions { Data Warehouse }

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

3552


How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

2032


what are the types in error loging?

825


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

1215


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

887






1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

1622


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

499


HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

975


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?

2603


How to find value from a column in a dataset?

1012


what are the errors faced while bursting the reports and how to solve those errors?

847


how to load the data to fact table?

1478


How do you setup Lo-cockpit?

1933


project Steps,hits, Project level HArd things,Solved methods?

922


what happens if the info.server doesn't find the session parameter in the parameter file?

859