Attributes of data stage
List out the main attributes of the data stage?
Expert
Data Stage has following features to assist the design and processing the required in order to build the data warehouse:
a) Uses the graphical design tools. Along with the simple point and click the techniques you may draw the scheme in order to present your processing requirements.
b) Extract the data from any number or types of the database.
c) Manage all the definitions of the metadata needed in order to describe your data warehouse. You may view and alter the table definitions at any point during the design of your application.
d) Aggregates data. You may alter the SQL SELECT statements which are used in order to extract the data.
e) Transforms data. Data Stage consists of the set of predefined transforms and functions you may use in order to transform your data. You may also easily increase the functionality by describing your own transforms to use.
Elucidate Where to keep informatica rejected data? How to remove the informatica rejected data?
To implement the priority queue what is the minimum number of queues we need?
Explain the following terms: Proactive, Retroactive and immediate Update.
Describe any two reasons which show the necessity of database redesign?
Give brief introduction of the term ‘Service Broker components’?
Explain for what the Supervisor module is used?
What is meant by the User Objects? Specify some of its restrictions?
State the benefits of the Business Objects over the other DSS?
What is meant by the snow flake schema?
Illustrates the Pointer a variable in data structure or not?
18,76,764
1949812 Asked
3,689
Active Tutors
1439214
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!