Sequence numbers can be generated in Datastage using certain routines. They are

-KeyMgtGetNextVal

-KeyMgtGetNextValConn

Datastage has two components

-Client Components – Designer, Director, Manager and Administrator

-Server Components – Server, Repository and Plug-ins.

- A tool for designing Extraction, Transformation and Loading

- An ideal tool for data integration projects system migrations

- Importing, extracting and creating metadata are within these jobs

- Data stage allows scheduling, monitoring and running the jobs 

- Allows to administer the development and execution in a single environment

- Physical Data Integration is all about creating new system that replicates data from the source systems.

- This process is done to manage the data independent of the original system.

- Data Warehouse is the example of Physical Data Integration.

- The benefits of PDI include data version management, combination of data from various sources, like mainframes, flat files, databases.

- A separate system is needed for handling vast data volumes.

- UDAI places the data in the source systems.

- A set of views are defined for providing access the unified view to the clients / customers.

- Zero latency of data can be propagated from the source system.

- The generated consolidated data need not require separate storage space.

- Data history and version management is limited and applied only to the similar type of data.

- Accessing to the user data overloads on the source systems.

Look for the existence of the following items:

- Generic Data Models

- An Enterprise Data Platform

- Identify the Data Sources

- Selection of a MDM Product

- Implementation of a Customer Master Index or appropriate alternative

Following are the data integration factors:

- Sub set of the available data should be optimal. 

- Noise/distortion estimation levels because of sensory/processing conditions at the time of data collection.

- Accuracy, spatial and spectral resolution of data.

- Data formats, storage and retrieval mechanisms.

- Efficiency of computation for integrating data sets to reach the goals.

Following are the benefits of data integration:

- Makes reporting, monitoring, placing customer information across the enterprise flexible and convenient.

- Data usage is efficient.

- Cost Effective.

- Risk adjusted profitability management as it allows accurate data extraction.

- Allows timely and reliable reporting, as data quality is the prime technology for business challenges.