DSXchange

Can someone please help of you have some idea?

I see that from previous posts but my question sis little different. How would it interact with IIS server? Do I need any specific settings?

also is the sequence of steps i have given is correct?

sorry. it's Team Foundation Server

Hi All,

I want to use TFS for Data stage jobs. Can some one please advise?

I plan to use below steps:
1) Install eclipse
2) Install TFS
3) Install TFS plugin for Eclipse

Is above correct? also how would I configure it for IIS? how Data stage would interact with it in information server manager?

Marking this as resolved . Since I started using TFS in a rather crude fashion to check in documents test case worksheets and DSX files and associated scripts. We may switch to CVS later on - once we have corporate blessings :). Hi Ramesh, Can you please help me a little bit how did you achieve thi...

Hi All,

I have one flat file with some name. I have data from some table. I need to join them using soundex function on name. How can I use Soundex function on joining keys?

Done. thanks

Hi all,

Is there any function in data stage which can suppress special characters in parameter. I am creating a date parameter having value like 2015-10-01

i need to get 20151001 from above string.

Please help.

Used To_NUMBER as a workaround with suspected field.

Hi All, I am reading using Oracle Connector Stage. When I run the same job with few records it run fine but with full data it's giving following error: The OCI function OCIStmtFetch2 returned status -1. Error code: 1,722, Error message: ORA-01722: invalid number. (CC_OraStatement::fetch, file CC_Ora...

Thanks. would look into it.

Can you help how to implement ROT13 in data stage?

no

only one column which has alphanumeric data

for example if my column has value A123456

it should be masked and presented as may be X456789

no particular sequence. It's just that original actual data shouldn't be present.

Hi All,

I need to mask varchar data. How can we achieve it without using data masking stage in datastage parallel job?

I need some process through which I can unmask it also later on if needed.

Can we use convert function on individual letters?