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 can you load data into target table without leading zeor's

4 25155

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

TCS,

3 7144

what is the use of layout component reference

Satyam,

3 16125

what is the difference between group span and level span

Satyam,

1 10304

can you please explain me pre session and post session options?

BTBP,

4 7735

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1 2279

How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 6144

How can we integrate different flat file data in a single mapping and with in a single execution

1 4670

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1 2008

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 8018

what are the default access rights in the teradata?

1 7357

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

TCS,

2 7700

I have a few records just I want to store data in to targets cycling way how?

Polaris,

1 2444

I have a few records all are same structures data, I want to store data in multiple targets how?

Polaris,

4 9098

How to lode data in sequntional files perform faster?

Polaris,

1 4381

Un-Answered Questions { Data Warehouse }

what are the names of the reports that you prepared?

1199

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1245

Explain in detail about scd type 1 through mapping.

1648

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

1212

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 ?

2550

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

2495

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

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

1144

draw informatica architecture 8.6 ?

3949

What is aggregate table and aggregate fact table ... Any examples of both?

1120

What is rollup component?

1341

Write the unconnected lookup syntax?

1153

What is dimensional table?

1168

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

1207

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

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