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

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

DELL,

2 8077

 Informatica Checkpoints

DELL,

3330

 Code page compatibly –Where all changes are made to handle the scenario.

DELL,

1 6150

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2048

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

Cap Gemini,

8 14392

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

Cap Gemini,

4 10509

Without using OBJECTS Can i write AND run a query in webi/desi? HOW?

Mind Tree,

3 8355

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

IBM,

3 6133

What is the difference between Sychronisatio and join?

Mind Tree,

2 7434

How to resolve the partial result error in the report

Keane India Ltd,

4 20704

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

ITC Infotech, TCS,

3 9810

how do the project develops? pls specify right from the start to end in step by steps.

ITC Infotech,

2221

Where we use PPI in real time??? What is the disadvantages of PPI?

IBM, Mphasis,

3 10723

What is the Maximum number of volatile tables that can be created?

Mphasis,

4 10232

What is a pseudo key? What is its use???

Mphasis,

2 18915

Un-Answered Questions { Data Warehouse }

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2890

What is incremental aggregation?

1084

Explain how to import oracle sequence into informatica?

1011

How can you implement many relations in star schema model?

1001

Describe what the SQL Server tempdb and tlog files are used for?

2340

Difference between server jobs & parallel jobs?

1077

Mention what is the difference between nodupkey and nodup options?

1010

How to select first n records in teradata?

1107

What are the types of schemas we have in data warehouse and what are the difference between them?

941

Can microstrategy desktop access operational data systems?

1070

Explain 4gt switch?

899

my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

4222

Compare aggregates and data marts

2765

Can a record be inserted and updated in database using microstartegy?

931

Differentiate between a database and data warehouse?

1143

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