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.
Illustrate briefly the term SQL sub query?
Illustrates the difference between a file server and database server?
Should I use numerous devices to take benefit of Partitions in Sybase?
Illustrate the multi value or multicolumn problem? Include an example not employed in the text.
Specify some of the areas where the data warehouses are utilized in the present and in the future?
Explain what is meant by the term universe stage?
How would the developer describe all variables using referential data types?
What are the disadvantages in File Processing System?
Explain about the stored-procedures and its advantages.
Specify the enhancements which are made within datastage 7.5 and also compare with the 7.0?
18,76,764
1932016 Asked
3,689
Active Tutors
1435684
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!