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

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

TCS,

2 8612

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

TCS,

7 10176

differences between service based and product based?

Satyam,

2014

What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?

Patni,

2 7679

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

Satyam,

3 7239

What is the architecture of ur project? can u explain it? PLz

Patni,

1 3641

Can we insert ,update ,delete in target tables with one update strategy tran.?

Zensar,

2 11441

why we use materialized view over view?

Zensar,

1 5301

can session assigned multiple mappings or not?

Zensar,

2 8143

we have to use order by,where,having we to implement sql query

Satyam,

1 5266

what is the default character set in teradata,,?

IBM, TCS,

2 11282

What is SQL Assistence?please eample

IBM,

4 8327

Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends

1 4374

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

Cognizant,

1 3099

in performance wise union is past,union all is past

2 5436

Un-Answered Questions { Data Warehouse }

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2179

Can any one explain about core dimension, balanced dimension, and dirty dimension?

1055

How to join 3 database like flat file, oracle, db2 in informatrica?

1236

scenario where i can use only concurrent execution of workflow.

3170

Can you define cognos impromptu?

1029

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1829

What do you understand by the cognos?

977

Can tm1 web be set up for load balancing?

What is data _null_?

1143

How do you Parametermap variables in Quiries?

2263

What is database exceptions in teradata?

952

name the sub-tabs which are in advance tab of ti?

What is lookup change?

1048

What are the various kinds of the hash file?

1149

What are the benefits of using AWS Redshift?

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