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

wat is synchronous and asynchronous reporting?

HSBC,

1 5100

Hi experts, can anyone tell how much we use plsql in real time

3 6828

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

Infotech,

2 9255

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 5838

how to identifie,is it innerjoin,leftouter join in lookup?

Hexaware,

2 36192

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

BRAD, TCS,

8 12641

how can we create tables in datastage?

1 12931

Difference between onRow and Onread method?

HSBC,

1 7135

In target table how to display the system time

1 4692

Did you face any problems while creating reports? Name? Solutions?

IBM,

3702

How were the reports scheduled and how to resolve unexecuted documents?

2681

What are templates? Explain what you have created?

1 4053

Have you worked with multiple data sources? If yes. How do you link them?

1 5291

What problems you have faced while creating an universe? tell me an incident and how you went about solving it?

Fidelity,

1 7186

Tell me about a complicated object you have created?

1 5976

Un-Answered Questions { Data Warehouse }

explain about balanced dimension,

989

What are the various file formats involved in reportnet?

989

Tell me about Propagate functions in informatica

929

How many input parameters can exist in an unconnected lookup?

1558

Can you explain data flow graph with an example?

1238

What is a lookup table in etl?

1196

What is the use of report studio?

1035

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2754

To import the flat file definition into the designer where should the flat file be placed?

1066

What is the function of output statement in a SAS Program?

1083

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

993

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

2004

What are the business intelligent tools to which Redshift can be integrated with?

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2374

1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

6886

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