Data Warehouse Interview Questions
Questions Answers Views Company eMail

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

AHM,

2 5813

what is main difference between change capture and change apply stages

IBM,

4 35679

difference between server shared container and parallel shared container

CTS,

6 18959

I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?

1 3377

How do you debug macros?

Accenture,

3 9179

Can We customize the Business Object infoview in BO?

2 8521

Is it possible to develop reports without Universe access?

IBM,

7 10774

Please Send to my e-mail Interview Questions With Answers , Technical Test Questions With Answers and Code Snippets Of Business Objects - Dev , Business Objects - Reporting Analysis .

AOL,

3 4328

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

TCS,

2 8174

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

TCS,

5 13207

can we put more measure on cross tab? If so how many? How this affect the aggregation?

4 8408

How do we run stored procedure?

1 5440

..Architectural difference between cognos reportnet and cognos8?

3 6129

hi,dis is kumari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is vicky_ceti@yahoo.co.in hope u will respond as soon as possible. thank u in advance

IBM,

26 27306

daily how much amount of data send to production?

HSBC,

4 7650


Un-Answered Questions { Data Warehouse }

In Teradata, how do we Generate Sequence?

595


what are logical views used for?

547


What is an i-server? What are the different modes to run it?

528


does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

5462


How can we Maintain the Cube Security by Category level and Dimension level ?

1947






what is SAS OPTIMIZATION?

1807


tell me 5 session failure in real time how can you solve that in your project?

1623


what are input dataset and output dataset options? : Sas programming

550


What is called data cleaning?

610


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

539


What is the difference between a cascading report and drill through the report?

723


In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?

590


Can we create multiple integration service on single repository?

693


What is SAS informats?

625


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

679