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

Can I create one wrkflw which will run different wrkflws on schedule time?

3 6560

Hi everyone, In my report i have ten pages like page1,page2, upto page10, i have textbox prompt when i enter 1 page1 should display,when i enter 2 page2 should display,can anyone suggest the answer.

4 8886

What is criteria for adverse events and treatment-emergent adverse events?

Accenture,

2 17917

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

Cap Gemini,

11 21279

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

TCS,

2 6672

suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me

2 5516

source file contains 100 records, i want 10 records in target file how it possible in datastage

IBM,

6 24471

hello, tell me the function which removes spaces from decimal field?

2 24203

what is song in infrmatica...?

CTS,

2240

if u having 2 pakages i want a report with report items in 2 pakages how to use the 2 pakages in single report please ans me............

Mphasis,

1 5340

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1922

if u generate a cube r pakage then its published we open in cc its ask every time for username &pass word?what we do?the pak r cube was not asking the password? what we do for this problem?pls ans me.............

1 4097

what do u mean by bridge group? where we r using this one?

1992

how many facts and dimensions in ur project and query items,how u deliver ur report to end users..i am going with fake exp...pls ans me generally what to ans..

Wipro,

2 6993

Cleared COG-112 with 100% score today. What next certification should i go for?

IBM,

1840

Un-Answered Questions { Data Warehouse }

What's the difference between timestamp (0) and timestamp (6)?

1201

Can you filter data in hashed file?

3780

Enlist the various types of transformations.

1063

Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

1008

how does the server recongnise the source and target databases.Elaborate on this

2695

How do y read Sequential file from job control?

15972

What is joiner change?

1152

What is the opening step in basic teradata query script?

1045

What is MPP in Redshift ?

What is the difference between using drop = data set option in data statement and set statement?

1166

Mention what is a partition and what are the different types of partition components in abinitio?

1187

How you will check the version of teradata?

1171

Name the types of gateway?

1012

Explain the different lookup methods used in informatica?

1049

how do you pull data from equifax?tell me the process?

1808

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