DSXchange

Thank you for the reply.

I am using the default partitioning for both Sort and Filter - Auto.
And there are no NULLs.

I am performing a Sort and then Filter to remove duplicates. However I have noticed that with every run the results change by 1 record. The output from filter after the sort give 15 rows (where keychange=1) for run 1 and produces 2 records rejected i.e. (where keychange=0). But for Run 2, 3 records ...

Thank you all for your suggestions.

Pandeesh,

I searched this forum and found answers related to the error but not with respect to the best practice related to the number of stages per a DS Job and how that could have negative impact on the performance of a job.

Thanks

I have a job with nearly 100 stages and has multiple instance enabled and it runs 8x8. Until now it was working fine but today the job erred with the below message: APT_PMPlayer::APT_PMPlayer: fork() failed, Resource temporarily unavailable Seems that the above is due to resource contention issues. ...

You are absolutely right. The Num() Function works perfect. Thank you

I have input data which is being read as varchar and it has to b parsed out to get the zipcode.
We have a requirement which asks to check for strings in this field(zipcode).

How do I achieve this in the transformer?

My input schema is Grp_ID Act_ID agtxid agtin And if I have a duplicate row then I use a sort sage to sort on all the 4 fields and set the key change column to true. So, in my transformer I want to put the word "MULTIPLE" if I see a duplicate record in a new output column. How can I achiev...

I have 4 columns in my input as below Grp_ID Act_ID Agntin Agtxid And I want to count the number of rows that are duplicate across the 4 columns. So I am using an aggregate stage and am using the count no of rows to calculate the no of rows by grouping on all the 4 input columns. I am outputting the...

My target is a flat file and it is varchar.

I have input data which is numeric and stored in 4 different fields as follows.


Century : 20
Year : 9
Month : 1
Day : 5

This data has to be formatted to arrive at the date in the format
2009-01-05 or 2009-01-05-HH.MM.SS.NNNNNN

How can I achieve this?

Thank you so much. It worked.

I have an input column called the Telephone field which is varchar. It has data such as below: Telephone (999) 999 9999 999-999-9999 999 999 9999 999/9999999 999*9999999 How can I strip off all these special characters and just keep the numbers? I want a format like 9999999999. I know I can strip th...

There will not be more than 3 id's in a batch. A batch can have less than 3 ids but not more.

I have 2 fields (id and name) such as Id Name 1 abc 2 def 3 ghi 1 jkl 2 mno 3 pqr 1 stu 2 vwx 3 123 1 456 2 789 3 111 The above records should be grouped into multiple batches with max batch size 3 records. And the combination of id and batchno should be unique. (Let's say I start my batch no.with 5...