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 8903

What is the Difference between sorter and aggregator?

2 8819

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 6486

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 15822

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,

2053

How many versions came upto now in SAS?

CTS, TCS,

3 10002

How to create a Ratio in Cognos Report studio Reports?

IBM,

1 12507

Types of Performance Tuning?

CGI,

2 8582

what will be the contents for a functional requirements specifications

2359

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

1 3850

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

Wipro,

2 9068

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

IBM,

2 6458

How to delete the duplicate colums in a sql table ?

IBM,

3 8147

Can we link the oracle and excel universess?

1 4607

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 5678

Un-Answered Questions { Data Warehouse }

How will you move hashed file from one location to another location?

2156

Why is business intelligence (bi) important in data warehousing?

949

Can you define query studio?

969

What will be the approach?

991

Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1955

What is a mapping?

995

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2085

What are the differences between proc means and proc summary?

1148

what is the difference between filter and condition?

1072

What is the size of database for you project?

1597

Could you explain what is enterprise data warehouse?

1151

Can you implement SCD2 using join, transformer and funnel stage?

1560

Enlist the functions performed by sas.

1130

Mention some types of transformation?

1048

What is the function of aggregator transformation?

1089

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