DSXchange

That routine i exported from production environment to development environment to make a change. There is some naming standards that i should follow.

By mistake i exported as read only from prod to dev.Now i need to modify it and export it to production.

Thanks

Hi,

I have to delete or rename a read only routine. When I attempt to delete or rename a read only routine it shows the message that read only object cannot be deleted. Please extend help.

Thanks

Thanks Arnd...

Field function itself suits my need.

Can we extract the decimal part alone using Iconv/Oconv.

I arrived at the solution by using the following code.
Substrings("3435.676",Index("3435.676",'.',1)+1,Len("3435.676"))
But it seems to be a round about.

Can we achieve the same using Iconv or Oconv....

Thanks

Thanks for ur reply,

Can I load the data of NVarchar datatype into a temporary table with varchar type and then perform transformations on the data using the temporary table as source further? Does it affect the data of that field?

Hi,

How to handle NVarchar datatype in Datastage Server job.

If we use varchar datatype for Nvarchar in Odbc stage...Will it makes a difference?

Thanx

Validation of the records should be like current value of D field should be equal to the previous value of E of that particular set of the child records. If B field in the parent record is 2 and C is 7 then 14 child records (7 sets containing 2 records each) for that parent record will be present. F...

Hi, I am facing a problem while executing the job sequencer . when i execute the job LoadingIndicatorCDataSeqFile individually its working fine for 100 records.there are abt 180 records in my table.For 101 th rec it gives the following error: jsCPM043LoadSeqFile..JobControl (@ja_LoadingIndicatorCDat...

Hi,

Change the Input column datatype in aggregator stage as Decimal(20,0) (In the sub properties) and pass the value as decimal into the aggregator.
This will remove the warning....

Thanks for ur response!!

But there is no hash file stage in px parallel job...
then how can i create a hash file??

Hi,

In a parallel job, Which suits large volume of data better...Fileset or Dataset..

Thanks

Hi

parallel job 1 uses a sequential file- transformer-sequential file.

parallel job 2 uses a sequential file-fileset-transformer-fileset-sequential file.

Is there a performance difference between these two jobs?
Is there a way to find the performance difference..

Thanks!!

Hi, Can I append a lookup fileset in a parallel job... I am having a sequential file as input and the data in it needs to be appended in a lookup fileset.Is it possible to append a lookupfileset. Can any one suggest me a way to append data from a sequential file to a lookup or lookupfileset so that ...

I actually tried MONTH.LAST in the transformer actually, since its a server job function and i am working on the parallel job, its not available in it. So i am trying to put the stage variable for the same. I am not sure of its performance issue, could any one please tell how to do this in a better ...

Sorry for my ignorance!! In 483-492 pages of parjdev doc , compress and expand stages are explained.how do they help out in debugging!! In datastage server job, we can debug using a watch window(debug option). but in the case of parallel job,is there any way to debug using watch window or thro any s...