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.
Write a brief note on the differences between a data warehouse and data mart?
What is Data Manipulation Language Compiler?
Illustrates the term Monopolistic Competition?
Explain what needs to happen to convert a relation to third normal form?
What is meant by the snow flake schema?
Specify the vaious types of data warehouses?
Describe how we can add a NOT NULL column to a table?
Elucidate briefly the term metadata reporter?
Illustrate the term data mart. What do you mean by it?
Which efficient data structure is used in RDBMS, for internal storage representation?
18,76,764
1943986 Asked
3,689
Active Tutors
1431598
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!