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 5829

what is main difference between change capture and change apply stages

IBM,

4 35753

difference between server shared container and parallel shared container

CTS,

6 19030

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 3391

How do you debug macros?

Accenture,

3 9227

Can We customize the Business Object infoview in BO?

2 8544

Is it possible to develop reports without Universe access?

IBM,

7 10823

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 4361

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 8202

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 13259

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

4 8425

How do we run stored procedure?

1 5463

..Architectural difference between cognos reportnet and cognos8?

3 6153

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 27484

daily how much amount of data send to production?

HSBC,

4 7734


Un-Answered Questions { Data Warehouse }

Which files are created during the session rums by informatics server?

709


what is guided navigation?

547


Can you define pivot?

545


What’s the difference between var b1 – b3 and var b1 — b3?

836


Whats there in global repository

1272






What is lookup change?

624


What are the types of dimensional modeling?

622


What is the roundrobin collector?

643


What are the operations that support avoiding duplicate record?

930


What do you know about abinitio?

765


What are some commonly used bteq scripts?

569


how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2293


what are several options for creating reports in web report studio? : Sas-bi

634


How would you configure wh authentication?

558


Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

497