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 8902

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,

2052

How many versions came upto now in SAS?

CTS, TCS,

3 10002

How to create a Ratio in Cognos Report studio Reports?

IBM,

1 12506

Types of Performance Tuning?

CGI,

2 8582

what will be the contents for a functional requirements specifications

2358

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 9067

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 8146

Can we link the oracle and excel universess?

1 4605

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 5677

Un-Answered Questions { Data Warehouse }

Does an informatica transformation support only aggregate expressions?

1049

What do you understand by user class in cognos?

955

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1535

What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?

1269

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1053

What is depict expression change?

1127

Mention few capabilities of sas framework.

1195

What is fact table? Explain the different kinds of facts.

1080

what is metadata? : Sas-bi

1035

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1050

define is catalog and types of catalogs in cognos?

What is maximum storage capability of SAS?

1428

When to use local filter and when to use global filter?

1001

When we should use 'jobid' for commit table (Output table component??

9107

How to convert RGB Value to Hexadecimal values in datastage?

4001

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