DSXchange

Thanks Swapnil,Ray for your responses.

Hi All, I am trying to update 10 records in a table in oracle which are having same Key column value i.e they are having the same group value, so I want to set Y to all that records within the group. I run the job on Default parallel node, it got aborted with the error -- Deadlock detected while wai...

Thanks chulett,

How we can implement in Server Job? If logic works then I can manage to use SERVER job only once for calculating this logic.

Yes chulett,

I am trying with Stage variables by comparing previous and current records. But not getting the results as expected, so looking for any other better solution.

Thanks,

I need to get G1 out of that...

Ray,

Even though three different values are there in COL3 for same group, I need to filter out that group If I see values ST and PB in col3.

Hi All, I have a requirement to identify groups which are having different values in a specific column, suppose if we have data like as below G1 M1 ST G1 M2 PB G1 M3 PD G2 M4 P1 G2 M5 P2 G2 M6 P3 Then I need to identify group G1 since It is having the values ST and PB in column 3. In the same way I ...

Thanks for your reply, I tried to read the sequential file by using the below options Record level: final delimeter-none record type- Implicit Field defaults: Delimeter - none Quote - none I have defined only one column in the sequential as record1 longvarchar(10000000). After setting this options I...

I am given a requirement to load a sequential file to oracle table. The sequential file has 133 rows, each row has a final delimiter end. In the Oracle table, there are two coulmns 1.Clob column 2.filename column. In the clob column , I need to load load the entire 133 rows as a single row. . When I...

Thanks Chulett, Priyadarshi, It means eventhough dataset is created on single node, when reading the same dataset from multinode, datastage automatically insert the tsort and hash operators internally and do a repartition the single node dataset data as per multinode requirements. Thanks, Good point.

Thanks Chulett, I am testing this job, it seems that I am getting the correct results but want to confirm with our expertise people here. If I am creating a hashed dataset on single node means all the records will go into one partition on that node, in other dataset records will be scattered along m...

Hi All, I have a requirement to join two datasets created in two other jobs. One of the job is running on single node and other is running on multi node. In both the jobs before creating datasets, data is sorted on key and hashed on key. In third job I am joining these two datasets on same key with ...

Thanks Ray, One more doubt, If i use two modify stages and one copy stage, it will create 3 processes on server. If i use transformer , it will create only one process on server though it takes much compilation time(I dont care compilation time). So here in this case, is it better to use transformer...

Hi All, I need to trim the input column first and then need to extract first 15 bytes of that column, I can do this in transformaer with simple derivation but i need to implement this in MODIFY stage. I am giving the specification as below COL2_ID=substring[1,15]((string_trim[" "](COL1_ID)...

Surrogate stage is working fine now, It is problem with the linux server. And regarding the Datasets on multinode, If the dataset is created with multi node and reading with a single node, then it is a probelm. It will throw error like below has n partitions, but only 1 is accessible from the nodes ...