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 7982

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 6672

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 11064

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 7901

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 12872

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 7191

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,

2034

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

CSC,

2302

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 8500

Un-Answered Questions { Data Warehouse }

Define datastores in cognos?

953

What are the advantages of using cognos sql?

1194

What is difference between e-r modeling and dimensional modeling?

923

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1091

Could anyone give brief explanation bout datastage admin

2350

Differentiate between odbc and drs stage?

1050

Can we use target hash file as a lookup ?

3326

1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

6874

Explain what is power center repository?

1007

what is session partitioning?

2127

What is the purpose of interprocessor stage in server jobs?

2233

which features do you use to check the data validations and errors? : Sas-administrator

1055

What is a table alias in obiee 11g? Where and how will you create it?

1009

Explain the difference between rolap and molap?

981

What is main use of mapplet?

1131

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