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

There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)

4 9039

What is the Difference between sorter and aggregator?

2 8945

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 6601

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 16040

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

L&T,

2109

How many versions came upto now in SAS?

CTS, TCS,

3 10162

How to create a Ratio in Cognos Report studio Reports?

IBM,

1 12617

Types of Performance Tuning?

CGI,

2 8689

what will be the contents for a functional requirements specifications

2424

Hi all, IF any one has Cognos Dump Questions please send it to my mail ID : jaya.purna@gmail.com Cheers Jaya

1 3921

How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?

Wipro,

2 9184

In a context can i get the data from two different factables by using the single data provider?

IBM,

2 6553

How to delete the duplicate colums in a sql table ?

IBM,

3 8323

Can we link the oracle and excel universess?

1 4675

Can anybody explain breifly about 5 tier's of BOXIR3. 1. Client tier 2. Application Tier 3. Intelligence Tier 4. Processing Tier 5. Data Tier

2 5788

Un-Answered Questions { Data Warehouse }

how do you debug and test your sas programs? : Sas programming

1180

What is the function of cognos dispatcher?

1283

if you use oracle sql*loader , how do you transform data with it during loading?

2144

What is the difference between constraind base load ordering and target load plan?

1164

Explain the different types of data warehousing?

1037

Describe routines in datastage? Enlist various types of routines.

1061

What are the differences between different versions of co-op?

1067

How to load the data from people soft hrm to people soft erm using informatica?

1073

Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

5202

What are the types of SCD?

1293

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

1059

Describe an informatica powercenter?

1203

Explain do we need an etl tool?

1076

What are parallel querys and query hints?

2281

how to remove duplicates using proc sql?

1203

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