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 39932

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

3555

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

2183

in static and dynamic which one is better

2 5293

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 10289

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

2248

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

IBM,

1 6829

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

IBM,

1 10925

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

Infosys,

1 10524

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

Infosys,

2 9517

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

Infosys,

3 14096

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

Infosys,

1 9538

types of errors in datastage?

Reliance,

2 9987

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

Reliance,

3 11440

how can we do null handling in sequential files

Reliance,

2 8704

Un-Answered Questions { Data Warehouse }

What is powercenter on grid?

1179

What are the differences between source qualifier and joiner transformation?

1062

what is epilog tab?

how can you import .csv file in to sas? : Sas programming

1098

Can we override a native sql query within informatica?

1036

What is meant by a Clique?

1063

where to store informatica rejected data? How to extract the informatica rejected data?

1005

What is the use of an aggregator cache file?

1199

what are the cubes developed in a sap bw project and what is the requirement for developing it?

2077

Explain the use of proc gplot? : sas-grid-administration

987

Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

2110

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2103

How we can create SAS USER DEFINED CODE?

2096

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2149

what is informatica metadata?

1037

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