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 5821

what is main difference between change capture and change apply stages

IBM,

4 35705

difference between server shared container and parallel shared container

CTS,

6 19007

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 9204

Can We customize the Business Object infoview in BO?

2 8535

Is it possible to develop reports without Universe access?

IBM,

7 10809

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 4347

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 8186

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 13230

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

4 8421

How do we run stored procedure?

1 5458

..Architectural difference between cognos reportnet and cognos8?

3 6147

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 27368

daily how much amount of data send to production?

HSBC,

4 7688


Un-Answered Questions { Data Warehouse }

how many maximum session supports to multiload in teradata ??

1694


What is native users?

721


How were the reports scheduled and how to resolve unexecuted documents?

2210


Difference between flat files and relational sources?

1770


How can we improve performance of data stage jobs?

612






Differentiate input and infile.

592


how to export or import the jobs in .ISX file

714


What is core dimension?

548


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

561


What is the difference between in process and inter process?

663


client know skid info?

1631


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1769


What are the features of SAS?

575


Compare ETL & Manual development?

549


How might you approve all mappings in the archive all the while?

600