DataStage Search

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

Workspace

Report Error

Subject: Data Warehousing

Q:

How do you generate Sequence number in Datastage?

Answer

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

-KeyMgtGetNextVal

-KeyMgtGetNextValConn

Workspace

Report Error

Subject: Data Warehousing

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.

Workspace

Report Error

Subject: Data Warehousing

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

Workspace

Report Error

Subject: Data Warehousing