DSXchange

Kumar,

I need to compare filed f1 of data set d1 with field f1 of Table X and then do aggregation of column C1 in table X.

Does aggregator allow usinf where clause or do you mean it to use in source SQL.

I have a table X which has records with 'n' columns. Then I will be classifying these recodrs as 3 data sets based on some conditions. For each record in each data set , A.I need to do sum of values in table X. B.I need to get the latest values for attributes from Table X. This is my Requirement. Da...

I need to pass columns from a transformer to target database stage such that the passed column should be used in where clause of SQL statemnet. Is this possible in DataStage.

Threre are many date fields in my target and to my surpsrise the first date field is 6th field how did you tell that.

The error is having same pattern for all the row.

I have grown through the post you have given, It talks about the format to be changed. i didnt get much on this

Hi Kumar,

There is user defined sql. But to_date() function is already used in it.

it is as follows:

TO_DATE(:6, 'YYYY-MM-DD HH24:MI:SS')


Ray,

In the sequential file the date is stored as 2000-11-08 00:00:00

default date picture for Oarcle is 'DD-MON-RR'.

How should I use date function here.

My mapping contains Decimal, Varchar and Date. I think this error is being thrown while mapping date field from Link Collector to Target.

I did'nt use any user defined sql, I am simply mapping from Link collector to Oracle Target stage. So, I cant use the function you mentioned.

Kumar, Retrieving records from one source doesnt take more time. Any how I will check it with sequential file. Meanwhile,I have given o/p of Link Collector to a sequnetial File,there was no problem in populating the file. But when I connected o/p of Link Collector to Oracle Stage, I am getting the f...

I am uisng Link Collector in my job to do a union between twe sets of records. I dont want to do an oracle union inside the soure stage. The union is happeneing using Link collector, but it is taking more time than it should be, is this slownees due to Round robin algorithm. How to improve the perfo...

Here goes Job A. Oracle Enterprise -> Change capture CC ------->Transformer -> dataset Orcale enterprise -> change capture CC For CC, two oracle stages as input , o/p from CC is given to tansformer then, from transformer to dataset. JOb B dataset -> transformer-> orac;le enterprise. WHEN running Job...

I deleted the post, but this error is causing problem for me

I reset the job, but I could not get any new error. "Where is Log from previous Rum"

There is one fatal error along with that warning:

Parallel job reports failure (code 138)

How to delete the post, i could not find the option

I am not running any script, I am loading dataset file in one job, and in another job I am trying to retrive te records from dataset. At this point the error is coming. I even tried dusing sequential file. The same problem.

My OS is Unix

I da dataset in one job and tried to access that dataset file, the output link from that dataset is given to a transformer. When I run the job its giving

Contents of phantom output file =>
17738 Bus Error

What is the poblem in this job.

I am new to PX and I am facing "first.rec schema is dropped " error. 1.how to uncheck Run time column propagation . 2.Also how to define the columns in Output Tab. "For the compare stage, all you have to do is define the following output columns: result : tinyint first : unknown (thes...

Can we pass job parameters to notification activity. I tried enclosing the job parameter in #. But the mail didnt get value for Job parameter, it got only Parameter name.