Datastage Interview Questions and Answers

31.	What is fact table?
	The chief feature of a star schema is the table at the center, called the fact table.

32.	What are the advantages of data warehousing?
	A data warehousing strategy provides the following advantages : Capitalizes on the potential value of the organization’s information. Improves the quality and accessibility of data. Combines valuable archive data with the latest data in operational sources. Increases the amount of information available to users. Reduces the requirement of users to access operational data. Reduces the strain on IT departments, as they can produce one database to serve all user groups. Allows new reports and studies to be introduced without disrupting operational systems. Promotes users to be self sufficient.

32.

What are the advantages of data warehousing?

A data warehousing strategy provides the following advantages :

Capitalizes on the potential value of the organization’s information.
Improves the quality and accessibility of data.
Combines valuable archive data with the latest data in operational sources.
Increases the amount of information available to users.
Reduces the requirement of users to access operational data.
Reduces the strain on IT departments, as they can produce one database to serve all user groups.
Allows new reports and studies to be introduced without disrupting operational systems.
Promotes users to be self sufficient.

33.	What is container?
	Containers are the reusable set of stages.

34.	What is the difference between local and shared container?
	Local Container is local to the particular job in which we developed the container. Shared Container is can be used in any other jobs also.

35.	What is orabulk Stage?
	This Stage is used to Bulk Load the Oracle Target Database.

FeedBack Form