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

why u go for dimensions ?

TCS,

3 9895

what are the difference between Informatica 7.1 and 8.1?

6 32416

Plz..let me know differences between Informatica 7.1 and 8.1?

3 11421

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 8686

How do we create row level security in cognos8?

3 10665

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

Tech Mahindra,

7 16939

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

TCS,

6 15089

What is an open session command in cognos connection?what is it meant for?

Infosys,

1 13981

Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)

Verinon Technology Solutions,

3 7775

What is meant by Tabular SQL in Cognos Report net

Infosys,

3 15067

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

Deloitte,

10 37182

what are the differences between powercenter 8.1 and powercenter 8.5?

2 9562

wht is full process of Information source to target just like stg to productuon and development

Informatica,

1 7198

what about data stage requirement

1 5366

what is power prompt in cognos ep7series?what is the use of this?

HCL,

1 3753

Un-Answered Questions { Data Warehouse }

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2127

What is dimensional table?

1166

What is rollup component?

1337

what are the names of the reports that you prepared?

1198

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2438

Explain how to generate iqd file from framework manager?

1022

how to generate the test data in sas without input data? : Sas-administrator

1207

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

4796

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1101

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2493

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2549

draw informatica architecture 8.6 ?

3949

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

3446

how many reports have u created ? explain a few.

2162

Explain about a time when you discovered a more efficient way to do a work task?

1224

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