DSXchange

anbu wrote:Sequence job is a server job. You can call IConv and OConv functions from User Variable activity

is it

can i call parallel job using sequence then?

anbu wrote:You can call IConv and OConv functions only from BASIC Transformer stage in the parallel job.

So it means I can't use these in user activity stage. How can I get it then?

mailravi.dw@gmail.com wrote:Use variable acvity and apply functions like iconv, Oconv then you easily get it through. if you need full information on iconv and oconv then refer the documentation. it clearly explained.

Thanks
Ravi

Can we use iconv and oconv functions in parallel stage?

Can I use user activity stage to create a variable who would have value abc201007
so basialy I want to do abc:transforms to append 201007.

Is it doable? if yes, how exactly?

Using Date function, you can know current date. From there, you can extract what you want and form a string (yyyymm) and then pass it as a parameter. This can be completely automated to run every month. File name is input parameter as in say input file for a transformaer stage. I can get this yyyym...

Hi, I have to schedule a job which would run on 2nd of every month. It would take last month's file as input. For example suppose this is being run on 2nd Aug, so it would use the input file of Jul. File have extension as yyyymm eg: abc201007. How can I pass a parameter whose values would dynamicall...

ray.wurlod wrote:Enable gathering of performance data and use the Performance Analyzer. ...

Hi Ray,

Can you please tell me where exactly would I get performance analyzer?

I went through the other posts in the forum... and got the solution - using copy, aggregator , filter then join back to get duplicates out....

Thanks to all of you!!!!

ray.wurlod wrote:Use a constraint something like Not(Num(Inlink.TheString)) ...

Ray, but it's varchar column type so not(num()) is going to be true even for 123 value. right?

chulett wrote:Should be. In the 7.x world it was all documented in the manual for the Director client, not sure where it might have ended up in the 8.x world. ...

Thanks!!!

Hi, A sequential file has 8 records with one column, below are the values in the column separated by space, 1 1 2 2 3 4 5 6 In a parallel job after reading the sequential file 2 more sequential files should be created, one with duplicate records and the other without duplicates. File 1 records sepa...

no no
what i meant
suppose i have 5 records like
abc
123
efg
rst
345

Then in put put i need only 3 records from above which would be
abc
efg
rst

how can I implement that?

chulett wrote:Make sure you understand what that does, jobs typically need to be designed with multi-instance capabilities in mind. There's more to it than simply flipping the switch.

Thanks Craig.... Is there any documentation about the same?

I need only alphabetic data out.

Hi, A sequential file has 8 records with one column, below are the values in the column separated by space, 1 1 2 2 3 4 5 6 In a parallel job after reading the sequential file 2 more sequential files should be created, one with duplicate records and the other without duplicates. File 1 records separ...