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

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1 1195

How to provide security in frame work manager for a query subject?

1 1037

How to improve session performance in aggregator transformation?

1 1044

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1 1092

What is a functional dependency f said to be minimal?

1 1190

How to eliminate duplicate rows from flat file?

1 1012

How to generate the cubes in framework manager?

1 1128

What are target types on the server?

1 1060

What is difference between model & package?

1 1100

What is the difference between constraind base load ordering and target load plan?

1 1179

How to add a number to a macro variable?

1 1061

What is the difference between drill through and masterdetail reports?

1 1283

What is the difference between narmal load and bulk load?

1 1507

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

1 1049

What is the use of tabular model, tabular sql, tabular reference in real time application?

1 1028

Un-Answered Questions { Data Warehouse }

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

2824

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.

1239

Hi friends, what are the new features in abinito3.0?

2860

What is dimensional table? Explain the different dimensions.

1269

What is node? How many nodes and amps used in your previous project?

1173

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 ?

2546

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2149

What is the purpose of Dataware Control?

1121

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

8286

What is a rollup component? Explain about it.

1243

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

1222

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421

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

3442

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

Write the unconnected lookup syntax and how to return more than one column.

1174

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