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 3482

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 7985

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 6673

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 11066

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 7903

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

Mind Tree,

1 7719

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

Infinite Computer Solutions,

1 12874

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 7193

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,

2036

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

CSC,

2303

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

CGI,

2 6391

explain about unit testing? in real time?

L&T,

2205

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 6140

wf dont have integration severances how you can run?

TCS,

1938

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

Cap Gemini,

2 8502

Un-Answered Questions { Data Warehouse }

What is grain of fact?

978

What is a node in teradata?

998

What is adaptive metric?

949

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1194

how to read the variables in sas? : Sas-administrator

1021

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2271

What are the data types in sas?

1062

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1955

How were the reports scheduled and how to resolve unexecuted documents?

2674

Is there any target staging area in informatica not staging area

2578

explain about dirty dimension?

1173

In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1984

Cleared COG-112 with 100% score today. What next certification should i go for?

1835

What do you mean by channel change?

1047

How do you verify a complicated sql?

1066

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