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 8097

 Informatica Checkpoints

DELL,

3337

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

DELL,

1 6168

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

2058

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 14434

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 10543

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

Mind Tree,

3 8383

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 6156

What is the difference between Sychronisatio and join?

Mind Tree,

2 7466

How to resolve the partial result error in the report

Keane India Ltd,

4 20741

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 9835

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

ITC Infotech,

2233

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

IBM, Mphasis,

3 10757

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

Mphasis,

4 10267

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

Mphasis,

2 18940

Un-Answered Questions { Data Warehouse }

What formatting can be applied to the information that is sent out by microstrategy narrowcast server?

1002

Give e an example of..

2348

Explain PDL with an example?

1333

How to load last n records of file into target table - informatica

1091

What is the difference between set functions and filter function in dimensional data?

2924

Explain can report net connect multiple datasource at a time in report creation time?

942

How can one identify whether mapping is correct or not without connecting session?

1461

Where the applications and where

939

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1110

What are tpump utility limitations?

1135

what is 'reconsideration error' and how can i respond to this error and how to debug this

2637

What is partitioning? Explain different types of partitioning?

1256

In Teradata, what is the significance of UPSERT command?

1249

What is virtual Data Warehousing?

992

What do you mean by a transaction file?

1270

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