0
Q:

How to perform incremental load in DataStage? 

Answer:
Q:

What is the difference between operational data stage (ODS) and data warehouse?

Answer

Data warehouse


- It is a decision support database system for the purpose of organizational needs. 


-It is non volatile, integrated and time variant collection of data


 


Operational Data Stage


- It is an integrated collection of information. 


-It can contain 90 days of information at maximum.


-ODS supports dynamic data.

Report Error

View answer Workspace Report Error Discuss

0 426
Q:

How do you generate Sequence number in Datastage?

Answer

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


-KeyMgtGetNextVal


-KeyMgtGetNextValConn

Report Error

View answer Workspace Report Error Discuss

0 574
Q:

What are the components of DataStage?

Answer

Datastage has two components


-Client Components – Designer, Director, Manager and Administrator


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

Report Error

View answer Workspace Report Error Discuss

0 360
Q:

What is DataStage?

Answer

- 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


 

Report Error

View answer Workspace Report Error Discuss

0 428
Q:

Describe about Physical Data Integration?

Answer

- 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.


 

Report Error

View answer Workspace Report Error Discuss

0 273