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

How do I CREATE an external dataset with sas code? I would like to create within a sascode a non-exsistent textfile on the host. So I am not forced to create the file befor filling it.

2 5024

what is intially documentation for a sas programmer?

Accenture,

2 6554

AE datasets names? how many types?

Accenture,

2503

what are the types in error loging?

Cap Gemini,

2148

What are the challenges you have faced in your project?

Cognizant, Infosys,

1 17877

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

TCS,

2 9676

Can we change Dynamic to Static or Persistent cache? If so what happens?

TCS,

2210

What is Java Transformation? what are the uses of it?

TCS,

2990

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

TCS,

7 15007

Explain the BO Developer WORK FLOW?

TCS,

3 9023

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

Polaris,

4 8083

what is intially documentation in sas?

Accenture,

1 5052

If a table contains 100 records we have to fetch 50-100 records from source to target?how

CSC,

7 12541

Are there any types of Dynamic Caches in informatica

Accenture,

4 8849

Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!

Wipro,

2010

Un-Answered Questions { Data Warehouse }

What is the difference between orabulk and bcp stages?

1026

what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

1091

What is pre-emptive and non-pre-emptive?

977

4. How many dimensions did you use in your reports?

1953

how to load dimension table and fact table. plz tell me the steps.

2094

What are the data types does SAS contain?

1114

Whats there in global repository

1693

What are the steps to do to use alerts in bo?

1394

Explain the different dimensions.

965

What is oltp?

977

In Teradata, what is the significance of UPSERT command?

1234

where to store informatica rejected data? How to extract the informatica rejected data?

1005

describe about physical data integration? : Sas-di

1045

what are the types of interactive display types? : Sas-bi

1100

Differences between business objects and web intelligence reports?

1223

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