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

What is polling in informatica ?

TCS,

1 12146

how can i add two different reports in the same document?

TCS,

5 11113

What is Lookup ,bridgeing tables where they will use in the Dataware house

IBM,

2 6727

How do you convert basic cube to transaction cube and transaction cube to basic cube?

1 2291

how to delete duplicate records by using filter transfermation?

3 8146

what is unit testing?tell me proceedure

L&T, UST,

1 2286

Tell me one complex query in oracle ?

L&T, Satyam,

2 8013

How to delete the data in the target table after loaded.

TCS,

3 9467

How can you display only hidden files in UNIX

Cognizant, L&T,

4 10845

I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage

IBM,

3 9394

what is diff b/t sorter t/r and agg have the option sorter property...

1 2246

How to delete the (flat file) data in the target table after loaded.

TCS,

2 7787

How can remove duplicates in a file using UNIX?

Cap Gemini,

3 12447

What all is needed to achieve an crystal report? A crystal report server ,User Id .Is BI/BO needed.Our source is Microsoft SQL Server 2008 Datacenter.Please guide.

Atos Origin,

1 2658

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1 2405

Un-Answered Questions { Data Warehouse }

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6056

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1193

How would you format some text using css to be verdana and bold?

1133

Explain how to generate iqd file from framework manager?

1010

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2081

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3439

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2339

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2054

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2759

what are the names of the reports that you prepared?

1185

How do you remove duplicate records in informatica? And how many ways are there to do it?

1224

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2161

What is rollup component?

1324

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4788

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1202

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