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

Explain briefly scd type2 in datastage7.5x2(parallel)

IBM,

1 6129

Order of Evaluation of Parameters

2 13447

How to convert RGB Value to Hexadecimal values in datastage?

4061

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

Satyam,

3 9243

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

iGate,

7 11245

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 9105

SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 5643

source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

US Technology,

6 9861

how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer

IBM,

2 6785

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?

IBM,

3 7277

solve the following loops? dimension table fact table fact table dimension table link will be there between tables?

4 8077

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this

2 6349

/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;

5 7731

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

CTS, TCS,

1 6538

What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

2183

Un-Answered Questions { Data Warehouse }

What is sort component in abinitio?

1283

What is the difference between view filter and report filter?

974

What are the types of containers in datastage?

1229

Explain what is ods (operation data source)?

1038

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2100

explain about various caches available in data integrator? : Sas-di

1120

What is the difference between a connected look up and unconnected lookup?

1005

what are the categories that sas informats are used to the place the data? : Sas-administrator

1098

Explain what sort of existing documents should business analysts refer to when starting on a new project?

1052

What is ods (operation data source)?

1063

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2589

Why might you create a stored procedure with the with recompile option?

1189

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1123

waht type of interface is used for testing the data in informatica

2302

Mention what dedup-component and replicate component does?

1086

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