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

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 12805

What is the main difference between a Joiner Transformation and Union Transformation?

5 32161

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1917

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5136

Which is the best training Institute for SAS Business Intelligence course?

6 8894

what is difference between migration project and integration project? can anyone explain with the example Thanks in advance

Satyam,

2 12863

how to find the rank in report studio? i need steps for this question.

2 5962

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

Wipro,

1 3620

How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.

2 6732

4 yrs etl devloper roles and responsibilities?any body give solutions

TCS,

2182

difference between informatica 8.1.1 and 8.6

TCS,

3686

draw informatica architecture 8.6 ?

Cognizant, TCS,

3883

complex mapping ur project u r invlve can u explain and give real time example give me ?

HGS, TCS,

2317

Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

Satyam,

2137

how to run workflow in unix?

Colgate, HP, Tech Mahindra,

5 24952

Un-Answered Questions { Data Warehouse }

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2639

How many codd's rules are satisfied by teradata database?

1123

Name the third party tools that can be used in datastage?

1093

tell me the rules and responsblites in our project(my project is development)

1944

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1390

Given an unsorted data set, how to read the last observation to a new data set?

1369

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

2380

Explain how to execute the plsql procedure from the report by clicking with mouse?

1062

Explain the difference between etl tool and olap tools?

926

What do you mean by mstr?

1111

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2069

What are the important features of datastage?

1144

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1026

Why is sorter an active transformation?

1145

what is requery in cognos?

2494

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