Datastage Interview Questions and Answers
Data Warehousing
Follow Us
TAGS
41. | How we can reuse the components? |
---|---|
Using the Shared and Local Containers. |
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. |
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 : |
44. | How we can reuse the components? |
---|---|
Using the Shared and Local Containers. |
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. |