DSXchange

Hi,
I have created Systm dsn for mysql.
But I am unable to import the table definitions ,which plugins or table definitions we have to use to import the table definitions?

Thanks in advance.

How to read .spps data using Datastage?

Thanks in advance..

I am using 8.1 and the length is 50.

Hi, How to separate the charcters and integers? Source has the one column ,the datatype is varchar and target has to be two columns. Ex: Source -----------------> Target Column -----------------> Char_col --- Num_col A1b2c3 -----------------> abc --- 123 Is there any pre-defind fuction? Thanks in ad...

Thanks,
How ISD is usefull in realtime ?

What is meant by Information Services Director and what is the use of this ?

Thanks in advance..

What is meant by validate ?

How to extract the data using sequential file if the source file contains more than 3 gb ?


Thanks,

How to replace a string with new string ?
My requirement is like

Name
krishna kishore
krishna prasad
krishna mohan

like this
but i want to replace krishna with Murali.
I cann't find any replace funtion in datastage. How do i do this ?

Thanks in advance.....

My source tables are like Source 1 table data source 2 table data cust_id cust_id 1 6 2 7 3 8 4 9 5 10 6 11 7 12 8 13 9 14 10 15 and i want to impliment like.......... target table x 1 2 3 4 5 y 6 7 8 9 10 z 11 12 13 14 15 any suggestions......... Thanks,

How to handle if Source file name is freqently changing like for
Ex file name is
Date_14-04-2011 and next day date_15-04-2011 so on like this.

Thanks,

can any one give the example of scratchdisk?

How to read multiple files using sequential stage?

What is Business Glossary and what is the use of business glossary?


Thanks

ok i will check it out.thanks