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 9038

What is the Difference between sorter and aggregator?

2 8943

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 6596

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 16026

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,

2108

How many versions came upto now in SAS?

CTS, TCS,

3 10153

How to create a Ratio in Cognos Report studio Reports?

IBM,

1 12612

Types of Performance Tuning?

CGI,

2 8683

what will be the contents for a functional requirements specifications

2422

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

1 3919

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

Wipro,

2 9181

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

IBM,

2 6552

How to delete the duplicate colums in a sql table ?

IBM,

3 8313

Can we link the oracle and excel universess?

1 4674

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 5782

Un-Answered Questions { Data Warehouse }

Mention the difference between ceil and floor functions in sas?

1216

Difference between Data and Index Caches?

1209

what r the job openings SAS for fresher graduates !

2506

Write some methods to apply securities in framework manager model?

1172

What is data stream and data adapter is it same are different? Explain?

1033

when will use SQL override in a lookup transformation?

2346

What are all the types of gateway used in Cognos?

1086

What is the difference between absolute filtering and standard filtering?

1118

What is ibm datastage flow designer?

1204

How create measures and dimensions?

1138

Explain level extension?

1122

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1994

How to design file watch jobs?

1025

What is microstrategy?

1033

How do you add default rules in the transformer?

1228

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