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

Could any one to tell Fact table Partitioning?

2 7160

how can i generate a report by getting values from two reports. the generated report should contain the 5 values of first report and last 5 values of second report. can any one guide me on this. pls... awaiting for the rply..

1 4962

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

FCS, IBM, Satyam, TCS,

5 27821

first of all i want say thanks to Zilanibasha, As u said that now these days Cirtification in cognos8 is only possible. Will u like to tell me in detail How i apply for cirtification As i m very much Interested.

1 4070

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

HP,

4 21157

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

HP, TCS,

6 19981

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

HP, Patni,

10 25380

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

HP,

3 12371

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

HP,

5 16966

Three date formats are there . How to change these three into One format without using expression transformation ?

HP,

3 11882

What is exact difference between Parallel Jobs and server Jobs..

IBM,

7 20429

How can we run same job in 1 day 2 times

IBM,

4 18482

Wat is pre-load in Hashed file

Patni,

1 10227

How can we run same job in 1 day 2 times

IBM,

7 23746

What is exact difference between Parallel Jobs and server Jobs..

DELL, IBM,

8 60785

Un-Answered Questions { Data Warehouse }

Hi friends, what are the new features in abinito3.0?

2855

What is dimensional table?

1152

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1654

Explain about a tricky situation for which you found a very simple solution?

1070

Write the unconnected lookup syntax?

1140

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2300

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8275

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1026

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1840

What is rollup component?

1327

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2340

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2425

How would you format some text using css to be verdana and bold?

1133

Explain about a time when you discovered a more efficient way to do a work task?

1214

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

1189

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