Datastage 7.5 and datastage 7.0
Specify the enhancements which are made within datastage 7.5 and also compare with the 7.0?
Expert
Several new stages were established compared to the data stage version 7.0. Within the server jobs stored procedure stage has been stoped, command stage, CDC Stage and producing the report option was there within file tab. In the job sequence several stages such as end loop activity, start loop activity, terminate loop activity and user variables activities were generally introduced. Within the parallel stored procedure stage, jobs surrogate key stages were introduced.
Provide a brief introduction of the term ‘Data Mart’?
Describe briefly the term data warehouse?
Explain the linked universes?
Explain the Rank, Router, Sorter transformation?
Illustrate the term indexing. Specify the kinds of the indexing.
Specify the types of join that are available?
Write down the differentiation between Informatica8.0 and 7.0?
Describe any two reasons which show the necessity of database redesign?
Describe the some drawbacks of a standard language like SQL?
Explain the usage of the repository connectivity?
18,76,764
1960963 Asked
3,689
Active Tutors
1457334
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!