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.
Specify the vaious types of data warehouses?
Write down the differentiation between view and materialized view?
Illustrates implementation of stored procedures?
What do you understand by the term SQL view in DBMS? Briefly describe the utilization of views?
In Sybase illustrates the term Table Partitioning?
Illustrates the ways to tune Reporting Services?
Briefly describe snow flake system design in database?
Explain Data Only Page Locking in Sybase.
Explain terms Data Cache in Sybase. Answer: It is the memory area where data which is required for the current queries running is bought by Disk upon to memory for
Will I find several users to network with, if I use NetLib? Answer: NetLib has been around in 1986, and has over users that are 20,000, world-wide. You will simply f
18,76,764
1958474 Asked
3,689
Active Tutors
1424946
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!