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 8713

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 9399

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

3814

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 5430

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

2163

how to generate means for every subject;

Mind Tree,

4 8203

how to change the execute of macro

Mind Tree,

2386

how to generate report for 0 observation dataset?

Mind Tree, Student,

3 7161

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

2 7154

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

Cap Gemini,

3 10855

What is Array bind size in universe? Plz

TCS,

2 19253

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 8130

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 7304

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 8383

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

SAS,

3 13062

Un-Answered Questions { Data Warehouse }

What is the difference between static and dynamic conditions?

1151

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4791

How will you solve the problem that occurs during update?

1109

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2445

What is the meaning of decode in informatica?

1167

What are datastage sequences?

1170

How to convert multiple rows to single row (multiple columns) in informatica

1429

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7190

define sparse cube?

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2261

Explain what is analytical or analytic mean?

1059

Explain how merging helps to combine data sets.

1118

What is the difference between project backlog and product backlog?

1614

Explain fact constellation schema?

1089

hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

2111

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