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 will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 7395

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

Patni,

1 2181

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

Patni,

1 2204

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

TCS,

1 2079

write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

TCS,

2 6267

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

HP,

2 6266

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

Accenture, TCS,

4 10018

write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh

Accenture,

5 11832

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

CTC,

4 26280

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

TCS,

1 6706

What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

Hexaware,

1 6478

In datastage can ve find the job based on source table name ??

TCS,

1 9550

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

Accenture,

2 6939

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

Cap Gemini,

1 3567

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

Bank Of America,

3 7769

Un-Answered Questions { Data Warehouse }

How to create the source and target database connections in server manager?

1139

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1231

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2168

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

1214

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2324

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2250

Write the unconnected lookup syntax?

1139

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1951

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6056

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2540

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2122

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2163

EXL informatica Questions

1451

Explain scd type 3 through mapping.

1065

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1993

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