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 polling in informatica ?

TCS,

1 12031

how can i add two different reports in the same document?

TCS,

5 10916

What is Lookup ,bridgeing tables where they will use in the Dataware house

IBM,

2 6605

How do you convert basic cube to transaction cube and transaction cube to basic cube?

2246

how to delete duplicate records by using filter transfermation?

3 7991

what is unit testing?tell me proceedure

L&T, UST,

2238

Tell me one complex query in oracle ?

L&T, Satyam,

2 7883

How to delete the data in the target table after loaded.

TCS,

3 9331

How can you display only hidden files in UNIX

Cognizant, L&T,

4 10629

I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage

IBM,

3 9277

what is diff b/t sorter t/r and agg have the option sorter property...

2194

How to delete the (flat file) data in the target table after loaded.

TCS,

2 7676

How can remove duplicates in a file using UNIX?

Cap Gemini,

3 12274

What all is needed to achieve an crystal report? A crystal report server ,User Id .Is BI/BO needed.Our source is Microsoft SQL Server 2008 Datacenter.Please guide.

Atos Origin,

2614

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2354

Un-Answered Questions { Data Warehouse }

How many transformations can be used in mapplets.

1951

Explain where do we use semi and non additive facts?

1030

Whats the difference between informatica powercenter server, repositoryserver and repository?

1182

is it possible to export the webi reports to crystal reports?with out using businessview?

2311

What is real-time datawarehousing?

1040

In warehouses how many schemas are there?

1089

Explain when we use aggregate awareness function in designer?

1043

What are universe requirements?

1063

Where do we use mapping variables in informatica?

1082

I need a good brd and uc template?

1099

CHANGE CAPTURE

1314

what is pmrep command?

2442

Explain the special input delimiters used in sas programming.

1020

Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2566

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

3032

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