DataStage and Informatica
Explain the term DataStage and Informatica?
Expert
a) Data Stage support the parallel processing however the informatica doesn’t.
b) Links are the objects within the DataStage ,in the Informatica it is a port to port connectivity .
c) In the Informatica it’s easy to execute the Slowly Changing Dimensions that is quite complex in the Data Stage.
d) Data Stage doesn’t support the whole error handling.
State the benefits of the Business Objects over the other DSS?
Describe briefly the difference between pessimistic locking and optimistic locking?
Explain some of the data mining tools.
Illustrate the difference between the data warehousing and OLAP?
State functionality of the repository manager?
Illustrate the use and application of the DB Miner.
Write down a short note on the term domain constraints?
Give brief introduction of the term ‘Service Broker components’?
Give a brief differentiation between Dimensional Modeling and ER Modeling?
What do you understand by the term ACID transaction in DBMS? Describe briefly?
18,76,764
1955383 Asked
3,689
Active Tutors
1420693
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!