FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

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
Your Name Your Email-ID
Your Answer
 
37. What is meta data repository?
  Meta Data is a data about the data. It also contains
  • Query statistics
  • ETL statistics
  • Business subject area
  • Source Information
  • Target Information
  • Source to Target mapping Information
Your Name Your Email-ID
Your Answer
 
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.
Your Name Your Email-ID
Your Answer
 
39. What is the default cache size?
  Default cache size is 256 MB.
Your Name Your Email-ID
Your Answer
 
40. How do you schedule or monitoring the job?
  Using the DataStage Director we can schedule or monitor the job.
Your Name Your Email-ID
Your Answer