1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

what is an ETL or ETT? And what are the different types?

 6911

how do u extract data from different data sources explain with an example?

 1768

what are the reporting tools and difference between them?

 1578

how do u automate Extraction process?

 1 3984

without using ETL tool can u prepare a Data warehousing and maintaining?

 3 7071

how do u identify the changed records in operational data?

QualTech,

2127

what is SMP AND MPP?

 8 61441

what are the facilities provided by data warehouse to analytical users?

 1660

what are the facilities provided by OLAP to analytical users?

 1 4050

what is HISTOGRAM? how to generate statistics?

 1 4169

how do u set the size of block buffer?

 1 3735

how do u implement unconn.stored proc. in a mapping?

 1 4138

if u can't find what you are looking for in lookup table, how do you handle?

 1 4611

why oracle is the best database for data warehousing?

HCL,

4 7430

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

 1666

Un-Answered Questions { Data Warehouse }

What are cognos connection initial page components?

589

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

532

What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?

1654

What are the Graph parameter?

676

3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

2118




Explain fastload in teradata?

588

Explain the mapping variable usage example in informatica

623

If a variable contains only numbers, can it be a character data type?

599

What is parallel processing in informatica?

1013

Tell me more about the parameters in macro? : sas-macro

581

Suppose we do not group by on any ports of the aggregator what will be the output?

561

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

3899

How to elaborate powercenter integration service?

639

What is catalog and types of catalogs in cagonos and which is better?

510

i was asked what are the caluclations done by you in your report? plz give reply

1695

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