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

how do u tune queries?

1 6711

what is metadata?

6 10437

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 12081

what is the difference between onsite & client site?

1 10550

what is the difference between the SAS v8 and SAS v9?

TCS,

7 25602

what is the SAS/ACCESS and SAS/CONNECT?

Accenture, iFlex, TCS,

9 35760

Can we replace a dataset into view?

CliniRx,

6 12795

Can Some one Explain How the Datasets from SAS can be loaded in to the MVS OS?

HCL,

1 4137

how do you read binary data in sas?

Satyam,

3 15664

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

Infosys, TCS,

2 18285

When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.

3 13333

how do u identify a macro variable

5 14376

How could you generate test data with no input data?

Quintiles,

6 16997

· What are some good SAS programming practices for processing very large data sets?

Quintiles,

6 21040

what other SAS features do you use for error trapping and data validation?

Quintiles,

3 8631

Un-Answered Questions { Data Warehouse }

How to create the source and target database connections in server manager?

1139

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2087

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

2054

Explain in detail about scd type 1 through mapping.

1641

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2163

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

Write the unconnected lookup syntax?

1139

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

2338

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2168

How to add default rules in transformer?

1276

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

2425

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8274

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2250

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 ?

2540

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

3439

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