Search found 40 matches
- Wed Jul 10, 2013 4:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading data into target through Oracle connector stage 8.7
- Replies: 2
- Views: 2107
- Wed Jul 10, 2013 3:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading data into target through Oracle connector stage 8.7
- Replies: 2
- Views: 2107
Loading data into target through Oracle connector stage 8.7
I am loading data into Oracle 11g. through Oracle Connector through Bulk load option. I am facing the error data type mismatch between colums Source and Taret colums. I cross check the Source as well as Target data base Data type and length are same. Still I unable to load or append data into target...
- Thu Jun 28, 2012 6:40 am
- Forum: General
- Topic: Datastage designer opening problem.
- Replies: 1
- Views: 1745
Datastage designer opening problem.
Hi All, I Installed datastage on Windows Server 2003 server. Installation succusfully completed. and I able login WAS server and Information Server. I succsfully create the Users also. But when I tried login in Datastage designer it takes user id /pwd and project name also but designer opens and sho...
- Thu Feb 09, 2012 8:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Mask in Hash file key colums.
- Replies: 5
- Views: 2444
- Thu Feb 09, 2012 4:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Mask in Hash file key colums.
- Replies: 5
- Views: 2444
Mask in Hash file key colums.
Hi All, I crreated the job with Hash file out put with 4 key(A,B,C,D) colums. but one of the requiremnet I need to reference this hash file as reference and in that I want to Join only one key colum (A), remain 3 key colums are not required to me. when do this job but its throughin error not compile...
- Tue Jan 31, 2012 8:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extracting data from DB2 table ~ character is missing
- Replies: 5
- Views: 2812
- Tue Jan 31, 2012 11:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extracting data from DB2 table ~ character is missing
- Replies: 5
- Views: 2812
- Mon Jan 23, 2012 11:12 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extracting data from DB2 table ~ character is missing
- Replies: 5
- Views: 2812
Extracting data from DB2 table ~ character is missing
Hi All, I am extracting data from table DB2. for one of the colum I defined as char. while extracting the ~ character its excludes. pantai dalam ~ gilly valuey -----> pantai dalam gilly valuey its skipping ~ value. I need ~ charatcter in Outputcolum. Please help on this. thanks bmsk
- Wed Jun 08, 2011 1:58 am
- Forum: General
- Topic: Need Help Datastage 8.5 Installation
- Replies: 4
- Views: 4426
- Wed Feb 02, 2011 12:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to handle two different date formats in same column?
- Replies: 7
- Views: 4457
- Tue Feb 01, 2011 8:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to handle two different date formats in same column?
- Replies: 7
- Views: 4457
How to handle two different date formats in same column?
Hi all, My input file contains date column. In this date is coming in the format yyyymmdd and ddmmyyyy format. But I want to do the date validation and convert into String. for that I am using valid function and StringToDate( "DateColumn", "%yyyy%mm%dd") But how to handle ddmmyyy...
- Tue Oct 26, 2010 9:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage client login error in 8.1 in linux Configuration
- Replies: 5
- Views: 5775
hi ray, i am able to open Websphere App Server console(port number 9060). And I am able to open http://ibminfosphere.hcl.com:9080/loginForm.jsp?displayForm=true. these things are opening. But when i open datastage client or Administrator ... its giving above errors Please give sujjustions regards bm...
- Tue Oct 26, 2010 5:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage client login error in 8.1 in linux Configuration
- Replies: 5
- Views: 5775
Datastage client login error in 8.1 in linux Configuration
Hi All, I am installed datastage server 8.1 in one machine and I am connecting server through to client. But i am getting this type of error Failed to authenticate the current user against the selected Domain A communication failure occurred while attempting to obtain an initial context with the pro...
- Fri Sep 10, 2010 6:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Deadlocked on lock resources
- Replies: 10
- Views: 7961
- Thu Sep 09, 2010 11:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Funnel
- Replies: 2
- Views: 1890