0
Q:

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

Answer:
Q:

How to perform incremental load in DataStage?

Answer

-Daily loading is known as incremental load.


-When data is selected from source, selected records are loaded between timestamp of last load and the current time 


-The parameter that are passed to perform are last loaded date and current date


-The first parameter is the stored last run date is read through job parameters


-The second parameter is the current date

Report Error

View answer Workspace Report Error Discuss

0 914
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 572
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 358
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 423
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