FeedBack Form

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

Datastage Interview Questions and Answers

Data Warehousing
Follow Us
 
TAGS
41. How we can reuse the components?
  Using the Shared and Local Containers.
Your Name Your Email-ID
Your Answer
 
42. What is the difference between primary key and partition key?
  Primary Key is a combination of unique and not null. It can be a collection of key values called as composite primary key. Partition Key is a just a part of Primary Key. There are several methods of partition like Hash, DB2, and Random etc. While using Hash partition we specify the Partition Key.
Your Name Your Email-ID
Your Answer
 
43. How do you eliminate duplicate rows?
  Data Stage provides us with a stage Remove Duplicates in Enterprise edition. Using that stage we can eliminate the duplicates based on a key column.
  Posted by Chandrasekhar Raju. (Jul 23, 2014)
 

There are three types of cursors are :
1. Remove duplicate stage
2. Transfomer stage
3.– Sort stage.
Your Name Your Email-ID
Your Answer
 
44. How we can reuse the components?
  Using the Shared and Local Containers.
Your Name Your Email-ID
Your Answer
 
45. What is transformer stage?
  Transformer stages do not extract data or write data to a target database. They are used to handle extracted data, perform any conversions required, and pass data to another Transformer stage or a stage that writes data to a target data table.
Your Name Your Email-ID
Your Answer