DSXchange

Can you please specify the exact meaning of What actually did not work?
This can be done using before job sub routine. You can fetch the value and pass it as a paramter to the job.

how many sequence numbers do you want to generate from the input column??

hi, sorry for reopening the topic. when iam executing the job to load data into the table then job is aborting. there are no constraints on the table also. Oracle_Enterprise_3,2: The call to sqlldr failed; the return code = 2; please see the loader logfile: /data/IBM/Scratch_1/ora.5114.498752.2.log ...

thanks craig
i guess we have to go with UPSERT mode only

hi, we have etl job which will take data from a dataset and load into the table through oracle enterprise stage the option in oracle enterprise stage is Write Method=Load Write Mode=Append The table has unique constraint defined on two columns col1,col2 the issue we are facing now is, there is alrea...

Hi, we have the requirement of splitting the value of a column and generate columns dynamically based on the delimiter present in the value. For example: I have a columns reference_columns in table T1. The column will have the value as COL1||COL2:COL3||COL4 the delimiter here is : . so we want to ge...

iam assuming you have a transformer in the job. in our case we dont have a transformer stage and we are not sure in which column does the new line character comes. and also we dont want to use the convert() funtion for all the columns in the transformer. that is the reason why we went with java tran...

Post it. Please. Sure In the UserProperties tab of Java Transformer stage we have given a parameter with the name ARGS and passed arguments in it. UserProperties ARGS=#$Parameter1#:#$Parameter2#:#ParameterSetname.Parameter3# we have done that way because we wanted our developers to use a single arg...

thanks everyone for the reply we have got a workaround for this problem. instead of keeping the data in sequential and then calling the java file to access the file, we placed the data in a dataset and the called the java class from the java tranformer stage which will write the data into another da...

we got the way to do it

Sorry for not being clear.
i want to pass the parameters that are present in the parameterset and also paramteres in job properties

also please tell me how to pass the parameters to java class from the java transformer stage and read the same in the java class.

Why not add it before then and then simply fill it there? ... hi craig, we are using the java file to develop a hash value(32bit encoded value) on some columns that are passed to jva transformer. After creating the hash value in the java file i am planning to pass it to the output link For example:...

hi, i have done a dummy job in which iam reading data from a dataset and pass it to a java transformer. In the java transformer iam calling a java class file which will change the varchar fields from lowercase to uppercase and then send the data to output link.the output link of the java transformer...

Have you checked with your client whether they want to keep those newline characters? Or is yours a site with no data governance processes whatsoever? We are actually having this problem. I want to convert those \n to some combination of characters when iam passing it to the sequential file and aft...