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 12807

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

5 32164

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 8897

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

Satyam,

2 12864

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

2 5964

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 3621

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

2 6741

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

TCS,

2185

difference between informatica 8.1.1 and 8.6

TCS,

3688

draw informatica architecture 8.6 ?

Cognizant, TCS,

3886

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

HGS, TCS,

2318

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,

2139

how to run workflow in unix?

Colgate, HP, Tech Mahindra,

5 24960

Un-Answered Questions { Data Warehouse }

Is there any way to read the ms excel datas directly into informatica?

1034

What is primary index and secondary index?

1041

What if the source is a flat-file?

1127

What would you change about your job?

2405

Explain what Proc glm does?

1234

On which interface you will be working as a developer?

1060

Does microstrategy web support clustering via cisco local router or any other third-party clustering software?

1006

What is the procedure for creating independent data marts from informatica 7.1?

1077

What is a dw? Why do we need it?

987

List any five applications of data warehouse.

948

What are the difficulties u faced while doing vital signs table or dataset?

2408

What is a node in Informatica?

1050

what is proc Index? and what is proc document?

2733

What is a lookup table in etl?

1206

AWS Redshift is basically works on nodes and cluster and which of following option Redshift is based on?

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