Data Warehouse Interview Questions
Questions Answers Views Company eMail

Suppose you find the term validation mentioned with a set of data, what does that simply represent?

675

What do you mean by the overflow errors?

879

What are the factors on which storage of data depends?

729

What kind of layouts does abinitio support?

739

List out the file extensions used in abinitio?

739

What are the different types of parallelism used in abinitio?

711

Explain how abinitio eme is segregated?

1074

We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

990

How to run a graph infinitely?

758

What are the benefits of data processing according to you?

805

What is expression transformation?

718

What are the different lookup cache(s)?

712

In informatica workflow manager, how many repositories can be created?

935

In informatics server which files are created during the session rums?

729

How are indexes created after completing the load process?

1094


Un-Answered Questions { Data Warehouse }

Explain the new features of teradata?

676


What are the advantages and disadvantages of reporting directly against the database?

618


What are the new features of informatica 9.x at the developer level?

699


What is a passive transformation?

726


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

699






What is rank index in rank transformation?

690


How many areas for files does datastage have?

722


Name few SAS functions?

757


Describe stream connector?

918


What do you mean by a transaction file?

758


What are the steps involved in designing a fact table?

571


How to perform incremental load in datastage?

765


what are the component of range? : Sas-bi

704


how do u catch bad rows from OCI stage? And what CLI stands for?

2398


How to add default rules in transformer?

779