Data Warehouse Interview Questions
Questions Answers Views Company eMail

What are the types of containers?

654

What is the use of datastage designer?

610

What are stage variables, derivations and constants?

641

Explain datastage architecture?

790

What are iconv and oconv?

739

What are the different plug-ins stages used in your projects?

602

How do you generate sequence number in datastage?

605

Define data aggregation?

633

What are the difference types of stages?

600

How do you schedule or monitoring the job?

635

What is staging variable?

600

Which algorithm you used for your hashfile?

666

What is apt_config in datastage?

669

What are the types of jobs we have in datastage?

649

How can we improve the performance in datastage?

627


Un-Answered Questions { Data Warehouse }

Differentiate between a repository server and a powerhouse?

554


How to handle multi value dimensions?

1760


What is amazon redshift?

1


What is the use of transformation?

555


explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

521






Explain the main difference between the sas procedures and functions? : Sas-administrator

514


Your application mode has crashed. How would you get the instance back?

508


Ist the schema that a data warehouse system can implements.

475


Why is dimensional normalization not required?

594


How will you enable or disable caching in the system level and table level?

455


Explain sessions. Explain how batches are used to combine executions?

568


What is the difference between user and versatile user?

550


how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1461


What is the function of union transformation?

594


Explain the definition of normalized and denormalized view and what are the differences between them?

495