Data Warehouse Interview Questions
Questions Answers Views Company eMail

What are the primary usages of datastage tool?

721

How many areas for files does datastage have?

722

What are constraints and derivations?

768

What are the types of containers and how to create them?

645

What are the benefits of datastage?

818

What are the different layers in the information server architecture?

729

What are the functionalities of link partitioner and link collector?

679

How do you reject records in a transformer?

723

How many types of stage?

788

what is ds administrator used for?

829

What are transforms and what is the differenece between routines and transforms?

714

What is the difference between round-robin partitioning and hash partitioning?

627

What is fact? What are the types of facts?

609

What is staging area referring to?

655

How etl testing is different from database testing?

609


Un-Answered Questions { Data Warehouse }

How to create or import flat file definition in to the warehouse designer?

716


what are the errors faced while bursting the reports and how to solve those errors?

1642


What are the Types of parallelism in detail?

788


Explain system call error?

684


What is real-time datawarehousing?

678






Difference between cold fusion 5 and cold fusion mx 6?

683


Explain target update override in informatica

726


How do you ensure simultaneous releases across multiple operating systems?

642


What is target designer and target load order?

743


What is the command used to run a batch?

662


What is the metric store database?

623


What is meant by a Highest Cost Plan?

703


What is the cumulative sum and moving sum?

865


What are some examples of informatica etl programs?

622


what happens if the info.server doesn't find the session parameter in the parameter file?

1622