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

I have very Latest Business Objects-XI Certification Dumps for all the Codes, If anyone need, mail at: AJITH.BOXI@GMAIL.COM

TCS,

39 41120

How can you import XML repositories exported from different tools like ODI

3608

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

2238

in static and dynamic which one is better

2 5415

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 10517

wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?

2308

how can u connect the client system directly at any time?

IBM,

1 6918

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

IBM,

1 11049

HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?

Infosys,

1 10617

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

Infosys,

2 9651

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

Infosys,

3 14261

can we see the data in fixed width file? how can u change the datatype of fixed width files?

Infosys,

1 9624

types of errors in datastage?

Reliance,

2 10128

on how many columns we can perform aggregation in the Aggregator stage?

Reliance,

3 11640

how can we do null handling in sequential files

Reliance,

2 8855

Un-Answered Questions { Data Warehouse }

Explain multivalued dependency?

1050

Explain in detail scd type 2 through mapping.

1097

Explain the definition of normalized and denormalized view?

953

How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1595

what is the effect of the options statement errors=1? : Sas programming

1109

What are the types of catalogs in cognos?

1200

Why did ibm cognos tm1 web change the technology from .net to java?

What is workflow? What are the components of the workflow manager?

1186

What are the features of SAS?

1092

how you provide security to reports? How you provide security to packages ?

1124

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

1036

Define Pmrep command?

1128

What is the difference between STOP and ABORT options in Workflow Monitor?

1332

What is the function of etl when used in data warehousing?

1009

What is data cleaning?

1009

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