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.
Search found 36 matches
- Wed Jul 25, 2012 4:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to connect MYSQL database?
- Replies: 1
- Views: 1778
- Fri Jun 22, 2012 12:59 am
- Forum: General
- Topic: How to read .spps data using Datastage?
- Replies: 2
- Views: 1849
How to read .spps data using Datastage?
How to read .spps data using Datastage?
Thanks in advance..
Thanks in advance..
- Thu Mar 15, 2012 11:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to separate charcters and integers?
- Replies: 17
- Views: 11099
- Thu Mar 15, 2012 1:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to separate charcters and integers?
- Replies: 17
- Views: 11099
How to separate charcters and integers?
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...
- Mon Nov 07, 2011 11:27 pm
- Forum: General
- Topic: What is meant by Information Services Director
- Replies: 3
- Views: 2173
- Mon Nov 07, 2011 10:49 pm
- Forum: General
- Topic: What is meant by Information Services Director
- Replies: 3
- Views: 2173
What is meant by Information Services Director
What is meant by Information Services Director and what is the use of this ?
Thanks in advance..
Thanks in advance..
- Thu Jul 28, 2011 12:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What is meant by validate ?
- Replies: 1
- Views: 1227
What is meant by validate ?
What is meant by validate ?
- Tue Jul 26, 2011 3:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file related doubt
- Replies: 3
- Views: 2251
Sequential file related doubt
How to extract the data using sequential file if the source file contains more than 3 gb ?
Thanks,
Thanks,
- Wed Jul 06, 2011 1:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to replace a string with new string ?
- Replies: 1
- Views: 2261
How to replace a string with new string ?
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 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.....
- Tue Apr 19, 2011 6:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to impliment this logic?
- Replies: 1
- Views: 1537
How to impliment this logic?
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,
- Thu Apr 14, 2011 6:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to handle if Source file name is freqently changing?
- Replies: 3
- Views: 2512
How to handle if Source file name is freqently changing?
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,
Ex file name is
Date_14-04-2011 and next day date_15-04-2011 so on like this.
Thanks,
- Fri Apr 08, 2011 3:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to know about the scratchdisk ?
- Replies: 3
- Views: 2924
Need to know about the scratchdisk ?
can any one give the example of scratchdisk?
- Thu Mar 31, 2011 5:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read multiple files using sequential stage?
- Replies: 3
- Views: 2672
How to read multiple files using sequential stage?
How to read multiple files using sequential stage?
- Wed Mar 30, 2011 12:44 am
- Forum: General
- Topic: What is Business Glossary ?
- Replies: 2
- Views: 2464
What is Business Glossary ?
What is Business Glossary and what is the use of business glossary?
Thanks
Thanks
- Wed Mar 30, 2011 12:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to add a zero to string with out using transformr stage
- Replies: 4
- Views: 2928