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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

Whether dimension table can have numeric value?

 593

Have you have ever worked in unix environment and why it is useful in datastage?

 637

Differentiate between hash file and sequential file?

 571

Define project in datastage?

 657

How to clean the datastage repository?

 686

How rejected rows are managed in datastage?

 909

Does datastage support slowly changing dimensions ?

 651

How many types of hash files are there?

 601

Nls stands for what in datastage?

 719

Define meta stage?

 769

Define orabulk and bcp stages?

 669

Define repository tables in datastage?

 693

How complex jobs are implemented in datstage to improve performance?

 584

Can you explain how could anyone drop the index before loading the data in target in datastage?

 880

How a routine is called in datastage job?

 597

Un-Answered Questions { Data Warehouse }

What is difference between model & package?

563

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

495

Explain how merging helps to combine data sets.

602

What is a ds designer?

633

Have you used Unstructured data?

824




Explain what are components of report studio?

562

How does a sorter cache works?

558

What does the trace option do?

656

What are the differences between joiner transformation and source qualifier transformation?

615

What is a pdv and what are its functions?

592

Can you define set to be cardinality?

579

Explain what is a three tier data warehouse?

537

Give one reason when you need to consider multiple data processing?

622

Differentiate between operational datastage (ods) and data warehouse?

664

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

562

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