Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
GT_SrDBA
Contributor II
Contributor II

How do I see the columns involved in replication?

We are having a lot of situations where teams are checking for new columns that have been added by the vendor.

I have to go to the source and insure the columns are there.  Then I go to the replicate and reload a table.  I would like to check if the column is part of the replication first.

I know how to add tables to the replication.  Is there a way to see the columns involved in the replication?

Thanks.

 

 

 

Labels (2)
1 Solution

Accepted Solutions
lyka
Support
Support

Hello,

 

You can do this by going to "Table Settings" > Transform tab

1. Open the task you are working with.
2. In Designer view, select the desired table from one of the following tabs on the right of the console:
3. Click the Table Settings button above the table list.
The <Table_Name> - Table Settings window opens.

4. Go to Transform tab

 

The Transform tab in the Table Settings window has the following components:

Input: This lists the columns on which you can perform transformations.

Output: This table shows the defined output for the columns in the table where you are performing
the transformations. It contains the following columns:

 

The input and output columns are the columns for replication,

 

Thanks,

Lyka

View solution in original post

2 Replies
lyka
Support
Support

Hello,

 

You can do this by going to "Table Settings" > Transform tab

1. Open the task you are working with.
2. In Designer view, select the desired table from one of the following tabs on the right of the console:
3. Click the Table Settings button above the table list.
The <Table_Name> - Table Settings window opens.

4. Go to Transform tab

 

The Transform tab in the Table Settings window has the following components:

Input: This lists the columns on which you can perform transformations.

Output: This table shows the defined output for the columns in the table where you are performing
the transformations. It contains the following columns:

 

The input and output columns are the columns for replication,

 

Thanks,

Lyka

GT_SrDBA
Contributor II
Contributor II
Author

Perfect. Thank you.