DSXchange

In the caluse 'where x=orchestrate.z'. So here both X and Z are primary key.

And regarding table locking I have not set any specific locking mechanism..as I do not know how to do it

we are not using any specific patitioning..It is Auto...

Sorry..yes there was a where clause like this where x=orchestrate.z

I am running a update query in oracle stage. The query is something like this update A set b=orchestrate.c, d=orchestrate.e This is supposed to update aroung one miilion record. The table A has around 10m records. Now the job is configure to run in four parallel nodes. When it is running 4 nodes it ...

hi,

Try using StringToDate(Trim(INP_DATE),"%yyyy%ddd")

~
Harshada..

yes you can add... you just need to login to web console and there u can add.. even though you donot have admin rights

Hi, We just installed IBM information server 8.0.1. Login to web console is fine but login to Datastage designer, administrator fails with error 81011. I have set up the datastage credentials as dsadm and it has the suite user and suite administrator roles. The IBM information server was installed b...

I am taking data from oracle and When i try to move this data into an XML
stage the job is running successfully but it is not creating any file in
the path defined (in options tab of output stage). What is the exact
procedure to do this? Can anyone give some more inputs on the xml
stages.

Hi, I was trying the Data Migration Assistant and was trying to create the job exactly as mentioned in Designer Guide Pg 324. When I tried to select the table definitation BuiltIn -> Examples->Folder, I get a error " Cannot open export Built-In-Examples-Folder.xml(Path/File access error)" ...

Hi, I was trying the Data Migration Assistant and was trying to create the job exactly as mentioned in Designer Guide Pg 324. When I tried to select the table definitation BuiltIn -> Examples->Folder, I get a error " Cannot open export Built-In-Examples-Folder.xml(Path/File access error)" ...

Hi, I have a job seq file read -> transformer - > seq file out in the transformer we o/p only some columns. this was the original design. But now i wanted to change the job to o/p few more columns. When I simply drag dropped the columns from i/p to o/p in transformer and compiled the job it gave me ...

Hi, I have a job seq file read -> transformer - > seq file out in the transformer we o/p only some columns. this was the original design. But now i wanted to change the job to o/p few more columns. When I simply drag dropped the columns from i/p to o/p in transformer and compiled the job it gave me ...

Hi Ray,

4 fields was an example. Maximum number of fields are needed as some records can have 4 and some have lesser than that number of fields. Need to convert all the variable records to fixed number of fields so as to process further.

Hi, I have input file having data as 1,abc,pqr,"hhhh" 2,"abc,yyy",pqr 3,lmn,"uuu,vvv" i.e. number of fields are variable. I know the maximum number of fields eg 4 in this case. Data is comma seperated and some data has quotes and some donot have. This is what is defined...