Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

Hi All, If anyone of you had very Latest & Authentic BUSINESS OBJECTS - XI Certification Dumps for the below Codes, can you please forward it to me, its really very urgent to me SABE 201, SABE 301, SABE 401, SABE 501V3.0 Thanks Mohan

3 6176

what are the cubes developed in a sap bw project and what is the requirement for developing it?

Maersk,

2137

what are the reports developed in sap bw project and what is the requirement for developing it?

Maersk,

2229

what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

Accenture,

2179

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

Accenture,

2685

in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?

Accenture,

2 10988

why varchar takes 2 extra bytes?

IBM,

4 15594

Which are SAS Windows Clients & SAS Java Clients

TCS,

3 10085

How can a SAS WEB REPORT STUDIO USER identify which report tabs they have been permitted without entering the SAS WEB REPORT STUDIO

TCS,

2 11368

how does sas know on which server the piece of code to be executed ? say if a proc olap code is written then how the sas application would detect on which server to execute.

TCS,

1 6575

What is SAS Information Map Studio and its purpose ?

SAS, TCS,

2 16092

what are different type of sas servers ? On which server does the sas code execute ?

TCS,

4 14802

what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.

TCS,

1 10074

HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?

TCS,

1 13148

what is SAS ACCESS AND SAS CONNECT ? Give an example and data statements used.

TCS,

1 6784

Un-Answered Questions { Data Warehouse }

How to get the first 100 rows from the flat file into the target?

1255

What is a Query Subject?

1149

what are Lookup caches options? Including persistent caches.

2031

Difference between PowerPlay transformer and power play reports?

2565

Explain what are the different versions of informatica?

1150

Differences between where and if statement?

1161

what is a prompt value in report studio and variables ?

2781

When can we choose the Redshift ?

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8315

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2536

What is informatica etl tool?

1061

can anybody tell me about complicated object you have created

3295

What is the difference between set functions and filter function in dimensional data?

2958

Name the types of report?

1013

Different sorts of metadata that stores in the storage facility?

1078

For More Un-Answered { Data Warehouse } Questions Click Here