Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is the difference between router and filter?

721

Can you highlight the main features of ibm infosphere information server?

740

What are the areas of application?

778

What is job control?

711

What is the precedence of stage variables,derivations, and constraints?

682

What could be a data source system?

656

What a datastage macro?

738

Why do you need stage variables?

799

On which interface you will be working as a developer?

718

What are data elements?

753

What is the difference between in process and inter process?

762

Highlight the main features of datastage?

698

What are the types of hashed files in data stage

740

What is difference between server jobs & parallel jobs?

710

What are the main differences you have observed between 7.x and 8.x version of datastage?

702


Un-Answered Questions { Data Warehouse }

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

692


what are the features in cognos8ui

1641


Tell me about MD5 functions in informatica

603


Explain the meaning of Amp?

672


what are the production issues in datastage?

9838






What is the use of teradata system software?

632


What are the functionalities of link partitioner and link collector?

679


Can you run multiple rpd’s in a single obiee instance?

500


Explain teradata utilities. What is multiload, fast load, tpump?

654


Explain what are the mapping paramaters and maping variables?

646


What are the string manipulation operators and functions associated with teradata?

725


Can a dimension table contain numeric values?

679


What is the difference between order and group variable in proc report?

966


Give the sizes of SMALLINT, BYTEINT and INTEGER.

765


How does a sorter cache works?

665