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

what is incompactabulity error in sap bo

2 7039

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

Cap Gemini,

5 13246

Difference b/n proc means and proc summary procedures?

Accenture,

3 9688

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

Cap Gemini,

5 11948

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 6265

There is any option to delete temp files automatically from temp directory in COGNOS? (without manual)

CTS, IBM,

1 7476

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.

Cognizant, UHG,

3 16606

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

TCS,

1 6876

INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?

CTS,

11 18757

Difference between the Sequence and Sequencer in DS?

TCS,

1 11911

Hi Techies..., can any one please answer me what is called unit testing ? how to do it and what are the steps involves in it? thanks for your answer......

1 4122

can we have to do changes in session property when we are dynamically generating target files?

Wipro,

3 9020

Types of error logs in Informatica?

2 12049

Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.

Amdocs,

4 8408

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

IBM,

1 5906

Un-Answered Questions { Data Warehouse }

What is the 4 + 1 view model as it relates to system modeling?

1040

Can you run multiple rpd’s in a single obiee instance?

790

What is orabulk stage?

1047

What is surrogate key? Where we use it?

997

What are the components of report net?

1268

Difference between stored procedure and macro?

1173

Explain heterogeneous mapping?

988

What is the basic syntax of a sas program?

1210

What is many-to-many dimensional model in datawarehousing ?

936

What is the differentiate between data file and descriptor file?

1363

How can you write parallel routines in datastage PX?

1015

What is data validation strategies for data mart v?

1092

Explain pushdown optimization and types in informatica

1079

any one answer me how they can analyzing the project using data ware housing?

2480

how to perform single sign in cognos by using url?

1154

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