DSXchange

Hi,


We are using the Teradata as Target Database. But in some tables we defined one column CUSTOMER_ID as Decimal now we want to modify as Varchar.

But we are not sure in how many and what exactly tables we have defined with the coulmn CUSTOMER_ID.

Instead of checking manually each and every job/Teradata Table

Is there any way in identifying that this particulor column using list of teradata tables?

Alternatively is there any way to Identify in which Jobs/Teradata Table we are using this CUSTOMER_ID.


Thanks in Advance

Select DatabaseName, TableName, ColumnName, ColumnFormat, ColumnTitle, SPParameterType, ColumnType, ColumnUDTName, ColumnLength, DefaultValue, Nullable, CommentString, DecimalTotalDigits, DecimalFractionalDigits, ColumnId, UpperCaseFlag, Compressible, CompressValue, ColumnConstraint, ConstraintCount, CreatorName, CreateTimeStamp, LastAlterName, LastAlterTimeStamp, CharType, IdColType, AccessCount, LastAccessTimeStamp, CompressValueList
From DBC.Columns WHERE DATABASENAME='<database_name>' AND COLUMNNAME='CUSTOMER_ID'

irajasekharhexa wrote:Hi,


We are using the Teradata as Target Database. But in some tables we defined one column CUSTOMER_ID as Decimal now we want to modify as Varchar.

But we are not sure in how many and what exactly tables we have defined with the coulmn CUSTOMER_ID.

Instead of checking manually each and every job/Teradata Table

Is there any way in identifying that this particulor column using list of teradata tables?

Alternatively is there any way to Identify in which Jobs/Teradata Table we are using this CUSTOMER_ID.


Thanks in Advance

If you need to look at the Jobs in DS, export the jobs / project into a dsx file and you can search for the CUSTOMER_ID field. If you have a advanced text editor like ultraedit you can infact count all the occurances of that particular field in the file.

Anrew

irajasekharhexa wrote:Hi,


We are using the Teradata as Target Database. But in some tables we defined one column CUSTOMER_ID as Decimal now we want to modify as Varchar.

But we are not sure in how many and what exactly tables we have defined with the coulmn CUSTOMER_ID.

Instead of checking manually each and every job/Teradata Table

Is there any way in identifying that this particulor column using list of teradata tables?

Alternatively is there any way to Identify in which Jobs/Teradata Table we are using this CUSTOMER_ID.


Thanks in Advance

If you need to look at the Jobs in DS, export the jobs / project into a dsx file and you can search for the CUSTOMER_ID field. If you have a advanced text editor like ultraedit you can infact count all the occurances of that particular field in the file.

Anrew

Thanks lot.

It's solved the Issue.