DSXchange

Hi, The job which i developed contains transformer T1 and from T1 to another transformer T2 directly. Similarly from T1 to a hash file and then to T2. This shows an error message job contains cyclic or linear dependencies and will not run. What is the reason for error and how to overcome it? Thanks,...

Hi, I am getting the following warning message.Anyone can please tell me the reason for this.... DataStage Job 154 Phantom 20476 Program "JOB.1062133866.DT.1384922442.TRANS2": Line 161, Nonnumeric data when numeric required. Zero used. Program "JOB.1062133866.DT.1384922442.TRANS2"...

The quickest way is probably to use a hashed file. Create 2 columns. Hard-code the first column with a value such as 'X' and make this the key column in your hashed file. Set the derivation for the other column in your transformer to @OUTROWNUM. As the rows pass through the hashed file they will be...

Hi Sengs, Your Question is not very clear. If you generate the Sequence No's in a transformer, "@OUTROWNUM" will contain the count. If you use @OUTROWNUM then your derivation would be max() for the @OUTROWNUM column.[/quote] Hi ravi, i am generating the sequence number in the transformer ...

Hi ravi,
i tried using the aggregator.But it is also not giving me the total count.Instead it is giving me a sequence number like 1,2,3...10 again.
Thanks,
sengs

Hi,
The job i designed generates a sequence number in the transformer stage.I want the total count of the sequence number in the target.
For example if the sequence number is from 1 to 10 then i want the count as 10 in the next stage.Help me in this regard.
Thanks,
Sengs

Thanks Arnd....
I think your point is correct.I will check out in unix for the permissions.
Thanks...

Hi,
I am getting an error when i run a job to populate a sequential file.
The error is
ds_seq open()_error in 'open()' permission denied.
Help me to overcome this.
Thanks,
sengs

Hi,
I want to read a flatfile and consolidate the mailing address using unix and sent a mail to the addresses using unix.Please suggest me in this regards.
Thanks,
Sengs