DSXchange

Yes A dataype conversion encounter error row 7 colum 8 like that

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...

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...

No My requirement in file level I can't use the Universe stage. draw back is that the job which is going to join is the Primary key there and here hash key combination columm not availble in that file. Only one colum availble. if select both side single key selection records are not coming.

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...

No its tilda in the table itself

No this is entire string and stored in colum in table DB2. "pantai dalam ~ gilly valuey " when extract from table to file its comming "pantai dalam gilly valuey " tilda character missing. DB2---->tran-----> seq in transformer I checking null and empty value.

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

hi

Go through the Installation and preconfiguration doucment which is coming along with software.

bmsk

Hi ray,

Please let me know the solutions from your side.

regards
BMSK

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...

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...

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...

After join u updateing all the colum?

While generating three files make sure all the colums of three files same datatype and size.

BMSK.