Datastage Interview Questions and Answers
Data Warehousing
Follow Us
TAGS
36. | What is the difference between active and passive Stage? |
---|---|
Passive Stages are used for data extraction and loading. Active Stage are used to implements and process the business rules |
37. | What is meta data repository? |
---|---|
Meta Data is a data about the data. It also contains
|
38. | What is the difference between join stage and merge stage? |
---|---|
JOIN : Performs join operations on two or more data sets input to the stage and then outputs the resulting dataset. MERGE : Combines a sorted master data set with one or more sorted updated data sets. The columns from the rccords in the master and update data set s arc merged so that the out put record contains all the columns from the master record plus any additional columns from each update record that required. |
39. | What is the default cache size? |
---|---|
Default cache size is 256 MB. |
40. | How do you schedule or monitoring the job? |
---|---|
Using the DataStage Director we can schedule or monitor the job. |