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 5924

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 7263

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

2 21369

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

TCS,

2 16725

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

4 11548

Why MLOAD needs Work Tables?

Teradata,

5 24294

Is informatica power center designer has 64 bit support?

1 5965

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

TCS,

2 7906

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 4462

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

1 9801

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 9248

how to create metric universe ?

TCS,

2407

how to create dashboard reports

TCS,

4 15002

what is extension list in abinitio?

1 7936

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

4 24395

Un-Answered Questions { Data Warehouse }

Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

2005

How can we improve performance of data stage jobs?

1073

Plz can any one say me how to get the informatica certification materials and dumps

2105

what are the others of "bad files" and "discard files" when using sql*loader?

2192

What is inner join and outer join?

1180

What are the benefits of using AWS Redshift?

can you please explain me pre session and post session options?

7681

Differentiate between operational datastage (ods) and data warehouse?

1234

any difficulitis have you phase while creating bo reports and how did u solve it

3512

What are prompted filters? Have you ever used them? Where?

1031

How can we run the graph?

1135

is it possible to index the data in cache of lkp transformation ?

2081

How many types of nodes supported by Redshift and what are the functions of nodes?

Define Dynamic push down optmization?

2350

how to create user defined function (udf) in informatica

1356

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