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 4915

what is intially documentation for a sas programmer?

Accenture,

2 6439

AE datasets names? how many types?

Accenture,

2448

what are the types in error loging?

Cap Gemini,

2092

What are the challenges you have faced in your project?

Cognizant, Infosys,

1 17769

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

TCS,

2 9545

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

TCS,

2152

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

TCS,

2908

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 14701

Explain the BO Developer WORK FLOW?

TCS,

3 8868

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 7895

what is intially documentation in sas?

Accenture,

1 4959

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

CSC,

7 12216

Are there any types of Dynamic Caches in informatica

Accenture,

4 8630

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,

1954

Un-Answered Questions { Data Warehouse }

What is the use of code page?

1013

Explain and compare pros and cons of snow flake schemas?

985

How abinitio eme is segregated?

1233

How big was your fact table

1745

What are the enhancements made in datastage 7.5 compare with 7.0?

1096

How can we use mapping variables in informatica? Where do we use them?

1101

What is data analytics in simple terms?

1082

How to update or delete the rows in a target, which do not have key fields?

1121

Explain the data types present in bo n wht happens if we implement view in the designer n report?

919

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1062

What is a macro routine?

2642

If you could design your ideal job, what would it look like?

2871

What are parallel querys and query hints?

2177

What is the use of stored procedures in teradata?

943

How do you convert single row from source into three rows into target?

1095

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