0
Q:

Explain the difference between star and snowflake schemas. 

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 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 915
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 573
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 359
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 424