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 5129

what is intially documentation for a sas programmer?

Accenture,

2 6626

AE datasets names? how many types?

Accenture,

2561

what are the types in error loging?

Cap Gemini,

2198

What are the challenges you have faced in your project?

Cognizant, Infosys,

1 17970

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

TCS,

2 9803

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

TCS,

2262

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

TCS,

3066

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 15274

Explain the BO Developer WORK FLOW?

TCS,

3 9153

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 8260

what is intially documentation in sas?

Accenture,

1 5132

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

CSC,

7 12773

Are there any types of Dynamic Caches in informatica

Accenture,

4 9015

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,

2059

Un-Answered Questions { Data Warehouse }

What are cluster in redshift? How do I create and delete a cluster in aws redshift?

Mention the difference between ceil and floor functions in sas?

1216

Mention a few design and development best practices for informatica?

1047

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9902

What is a core dimension?

1121

Can we Save (save as) WEBI Doc as DESKI?

8305

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

1101

What is the differentiate between data file and descriptor file?

1415

How many dimensions are there in informatica?

1139

What is an object prompt?

1075

All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

2149

What is aggregate cache in aggregator transformation?

1205

Explain BYNET.

1057

how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

1199

Code the tables statement to produce a multi-level frequency?

1051

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