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

how to return multiple columes through through un-connect lookup?

DELL,

1 6894

explain one complex mapping with logic? sales project?

Accenture, JPMorgan Chase,

6596

Performance tuning in UNIX for informatica mappings?

CGI, CTC,

2509

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 2935

How to do the error handling of if ur source is flatfiles?

1913

In ur current projectu have done any performance tuning of mappings?

1 4539

In which scenario did you used pushdown optimization?

1 3222

In which scenario did u used Mapping variable?

Cognizant,

1 2595

In Which scenario did u used Incremental loading?

2 6053

Did u used latest transformations of 8.6.0? for what?

1826

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 7501

what is semi-additive fact?where did u used?

2 5260

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 3858

In dimension and fact table? which one holds big data?

2 6307

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

ACS,

3 7637

Un-Answered Questions { Data Warehouse }

what are the considerations when picking a SAS/STAT procedure?

3327

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

1746

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10633

Explain adhoc reports?

873

Mention how to limit decimal places for the variable using proc means?

1060

What are the parameters of scan function?

1109

What is Session and Batches?

1042

What are the important Features of Redshift?

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1904

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3608

How will the AWS redshift work?

for whom is sas data integration studio designed? : Sas-di

949

Describe routines in datastage? Enlist various types of routines.

954

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1076

What does microstrategy desktop allow users to do?

857

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