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

What is univariate n where it can be used n how...?

2 7482

What r all the reporting procedures...?

3 7045

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 6616

can a fact table contains textual information

HCL, HCL BSERV, IBM,

6 14472

difference between function and procedure...

IBM,

1 6307

What are the new features of informatica 9 version?

2 8782

What is Relational Integrity?

1 4181

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

Deloitte, TCS,

3 17939

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

Deloitte,

3 26470

What is the difference between IN and Exists in Oracle?

Deloitte,

4 18474

Can we have a Mapping without a Source Qualifier?

Deloitte,

14 50346

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

Deloitte,

2 13320

what is the use of Java Transformation in Informatica 8.x?

TCS,

2 13898

Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith

2 5719

How applying "Level Span" in Cognos 8.3?

1 10436

Un-Answered Questions { Data Warehouse }

Explain how abinitio eme is segregated?

1569

I need a good brd and uc template?

1148

How a server job can be converted to a parallel job?

1148

How many areas for files does datastage have?

1221

What is data mapping and data modelling?

1617

What is the use of PROC gplot?

1213

What is a joiner transformation and why it is an active one?

1169

How does the aggregator transformation handle null values?

1197

How to find duplicates in a table?

1282

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8325

How many types of sessions are there in informatica.please explain them?

1218

What data formats does Redshift Spectrum support?

explain the proc in sas? : Sas-administrator

1141

Explain the aggregator transformation?

1225

Define query studio?

1048

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