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 5023

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 17876

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 15006

Explain the BO Developer WORK FLOW?

TCS,

3 9022

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 12539

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 report as filter in microstrategy?

917

difference between repository database and repository service?

1150

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

2446

How can you create a macro variable with in data step? : sas-macro

1042

How to perform incremental load in datastage?

1203

Explain what are the steps to be taken to schedule the report?

1108

what is use of SDR function?

5173

What is informatica worklet?

1067

What is the benefit of session partitioning?

1116

What are the difference between sas functions and procedures?

1155

Can you explain cognos planning?

1092

How to clean the datastage repository?

1127

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

1012

CHANGE CAPTURE

1300

Explain data flow graph with an example?

1127

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