Data Warehouse Interview Questions
Questions Answers Views Company eMail

How can you connect eme to abinitio server?

1 3258

What is a partition and what are the different types of partition components in abinitio?

852

What information does a .dbc file extension provides to connect to the database?

817

What is sandbox?

817

Explain how you can run a graph infinitely in ab initio?

749

What is the difference between partitioning with key / hash and round robin?

732

What is de-partition in abinitio?

999

What is rollup component?

768

What is sort component in abinitio?

789

What is a rollup component? Explain about it.

769

How to add default rules in transformer?

779

Define query studio?

669

What is main difference mapplets and mapping?

657

Define metrics studio?

657

What are the types of studio?

788


Un-Answered Questions { Data Warehouse }

What is smp and mpp platforms?

610


Explain system call error?

684


Compare dataset and fileset?

652


have u done any performance tuning? how u ll do?

1961


what do you mean by security filter?

646






What are the main features of datastage?

756


What is junk dimension? What is the difference between junk dimension and degenerated dimension?

689


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1040


What is Redshift Spectrum?

5


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

935


Why fact table is in a normal form?

629


what is online view?

1611


What you mean by drill across and what is the difference between drill through, drill across?

637


Can we change Dynamic to Static or Persistent cache? If so what happens?

1810


How do you setup Lo-cockpit?

2712