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 to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.

IBM,

1 3569

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

iGate,

4 8131

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 IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

Wipro,

2 6780

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

DELL,

5 11258

Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

TCS,

5 8065

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

Mind Tree,

1 7803

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

Infinite Computer Solutions,

1 12951

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

IBM,

3 7359

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

CTS,

2091

tell me 5 session failure in real time how can you solve that in your project?

CSC,

2398

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

CGI,

2 6483

explain about unit testing? in real time?

L&T,

2265

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

Polaris,

1 6221

wf dont have integration severances how you can run?

TCS,

1991

how can run the wf through pmcmd commend? write script?

Cap Gemini,

2 8604

Un-Answered Questions { Data Warehouse }

Are you involved in writing the inferential analysis plan? Tables specifications?

4009

Define ds designer?

1330

Can there be sub steps of etl steps?

1107

What is lookup table in etl testing?

1235

How do you load alternate records into different tables through mapping flow?

1929

What are the data movement modes in informatica?

1213

how to write server Routine coding?

2185

what is sas and what are the functions? : Sas-administrator

1036

What is a rank transform?

1148

What are the special input delimiters used in SAS?

1244

Explain four-tier connection?

985

How to load data in informatica ?

1070

Explain the types of transformations?

1106

What are the different layers in the information server architecture?

1177

What are the steps needed to create a simple basic datastage job?

1309

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