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

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 5820

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 7159

Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 21269

How can we get multiple output values using an unconnected lookup transformation?

TCS,

2 16614

If you need latest cognos certification dumps to get certified in first attempt with 100% score, please e-mail to getmecert@yahoo.com

4 11414

Why MLOAD needs Work Tables?

Teradata,

5 24096

Is informatica power center designer has 64 bit support?

1 5887

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

TCS,

2 7791

Hi All, I have found out this site very interesting and knowledge sharing site.I was wondering if you can tell me where I can get study materials for the BO XI 3.1 or suggest me the one that you have taken recently. Regards, Ace

1 4401

Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik

1 9726

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 9060

how to create metric universe ?

TCS,

2355

how to create dashboard reports

TCS,

4 14868

what is extension list in abinitio?

1 7840

how can you convert 3 way to 7way partitioning in abinitio?

4 24249

Un-Answered Questions { Data Warehouse }

Hi, If anyone has base SAS certification dumps, please share.

1870

What is the function of Stop statement in a SAS Program?

1161

What is a macro routine?

2733

How to do performance tunning of reports?

2322

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1136

What is apt_config in datastage?

1145

What makes sas stand out to be the best over other data analytics tools?

1077

What is the difference between Datawarehouse and OLAP?

930

What is sorter transformation?

1057

What is the difference between user and versatile user?

1078

What do you understand by overflow errors?

1249

Where the applications and where ware house management system is used?

1018

------------- How to identify the Revenue Column in Report?

2394

What are multi-group transformations?

1117

Where we use afc in actuate?

1036

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