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 the difference between breaks and sections?

3 8563

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

DELL, iGate,

2 9302

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3759

I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers

IBM,

1 5337

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2110

how to generate means for every subject;

Mind Tree,

4 8031

how to change the execute of macro

Mind Tree,

2315

how to generate report for 0 observation dataset?

Mind Tree, Student,

3 7041

"What is the difference between proc sort nodup and proc sort nodupkey?"

2 7045

What are the types(Specific Names) of Scheduling in BO?

Cap Gemini,

3 10700

What is Array bind size in universe? Plz

TCS,

2 19131

What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.

Collabera,

3 8000

what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????

TCS,

1 7228

cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle

TCS,

3 8231

what is the difference between informat$8. $char8.

SAS,

3 12949

Un-Answered Questions { Data Warehouse }

Do you think effective communication is necessary for data processing?

1219

What is a pdv and what are its functions?

1153

What is the difference between power center & power mart?

984

What is the difference between validated and compiled in the datastage?

1293

I have a flat file, want to reverse the contents of the flat file

1128

what do you mean by kimball?

1002

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

953

define cognos connection?

How do you remove duplicate records in informatica? And how many ways are there to do it?

1167

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1125

Explain adhoc reports?

942

How to publish a package by running Java Script?

2086

What is AWS Redshift is used for ?

What is a standalone command task?

1205

What is the order of application for output data set options, input data set options and SAS statements?

1561

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