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

why we use stored procedure transformation?

IBM,

4 9059

how to limit number of rows in a report in business objects using webi?

Cap Gemini, TCS,

3 19846

HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com

FIS,

5 11003

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

MGL,

2 7915

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

Infotech,

5 10184

what are the roles and responsibilities of teradata DBA ?

TCS,

1 28134

what are the day to day activities of teradata DBA ?

TCS,

5824

what are the roles and responsibilities of BO Administrator ?

OCS Infotech, TCS, Wipro,

1 23418

what are the day to day activities of BO administrator ?

TCS,

3024

Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please

HCL,

1 11988

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

IBM,

6 30964

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 4321

What is the need of building a data warehouse?

2 4830

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

IBM,

1 4160

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 6516

Un-Answered Questions { Data Warehouse }

What exactly do you know about catching in teradata?

1038

What are the functionalities of link partitioner?

1022

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

837

Explain lookup transformation in informatica

1074

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2325

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1503

what specific features and functionality do you get with olap services?

966

How to extract the informatica rejected data?

1221

Explain the difference between filter and conditin?

965

Explain what is the difference between power center & power mart?

999

Define Routines and their types?

1187

describe the Steps to confiure a Qlogic switch

2383

Mention a few design and development best practices for informatica?

999

What is an i-server?

1059

What are the areas of application?

1152

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