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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is operational data store (ods)?

 550

Explain dimension table ?

 549

What is bi?

 554

Explain is fact table?

 502

What is difference between content store and content manager?

 533

What is difference between informatica power mart and power center?

 554

What are the batches and it’s details?

 553

Explain difference between powerplay transformer and power play reports?

 529

What is metric store database?

 554

Explain informatica architecture?

 543

Define cognos report net?

 547

What is difference between data mart and data warehouse?

 535

How to join multiple db in catalog?

 559

How do you call a store procedure within a transformation?

 539

Different circumstance which drives informatica server to expel records?

 543

Un-Answered Questions { Data Warehouse }

What is the 4 + 1 view model as it relates to system modeling?

584

what are the all possible features supported modify stage?

1602

How to go to the older version for a mapping?

586

Name the different sorting methods in datastage.

599

write a query to retrieve the latest records from the table sorted by version(scd)

625




What do you mean by query studio?

498

What is union transformation in informatica?

684

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

661

Explain me ETL project architecture in Detail?

1914

What are the different types of variables in obiee 11g? Explain

466

What are the common features of Redshift?

5

What is a dw? Why do we need it?

525

List the logical and conditional operators that are used with teradata along with their meanings?

540

How to implement complex jobs in data stage?

602

Two default user groups created in the repository are____and_____.

1637

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