DSXchange

kumar_s

Ok I'm agree with you that I'm not very explicit and I didn't mentionned the error message . But It's not stupid to switch to using an other method, It can be interesting for Dsxians to know the different solution of a request ... HI kjaouhari, It is no wehere mentioned as stupidity to switch betwe...

kumar_s

If any activity aborts in the JobSequence, the control comes to the ExceptionActivity stage and its consicutive stage for action. As Craig mentioned you can use to contorl to notify or alert.

kumar_s

Use this in a command activity prior to the job being called, and pass the output as parameter.

Code: Select all

wc -l <filename> | cut -f1 -d ' '

kumar_s

How many records will be there in the gap? If the number of record in the gap is less, say 1 or 2 or 3 it ok, else you need to have that many stage variable to hold the values to compare and give as output. For that case, you can build you own custome stages or routien to have the looping funtion in...

kumar_s

These process can be taken once the maintanance of the user ids become difficult and tedious. Because this good numbers may boost up the add for the site.

IMHO.

kumar_s

You can use your user defined select query as

Code: Select all

select a.empno, a.ename , a.dept , (select sum(b.sal) from tablename b where a.dept = b.dept group by b.dept) As SAL from tablename a

kumar_s

But Iam sure you can manually make a conditional check for the duplicates to get rejected using transformer.

kumar_s

Thanks Roy, Krrish , opda.....

All your words encourages me a lot. :D
(To reach Roy soon

)

kumar_s

I have seen this when using CFF with many levels of records.
Do you use transformer in between?

kumar_s

You have JOBTYPE in DS_JOBS to indicate this.

Server jobs - 0
JobSequnce - 2
PX Jobs - 3

kumar_s

Clearing the status would be more dangerous than reseting. By CLEARing the status, the status might have turned to Reset, but at background the process would still be running or still have the connection open. Which will be one of the cause for a zombie process to be created. Which will inturn creat...

kumar_s

Not LAST but Maximum option it left out in aggregator.
Or simply SORT it based on the key and mark Allow Duplicate = False.

kumar_s

Thanks Chuck

I know you will be waiting for this turn.

Here the Nos doesnt matter. Still I need to learn a lot from them.

kumar_s

For this "Intermittent Problems" a patch has been relased by Ascential. But that too only for customers who asks for it. Else the general solution from the support team would be to turn of the monitor.

kumar_s

This can be easily acheived by CONVERT() function in datastage. But not sure what are you trying to do with "other than the Datastage inbuit functions "

Search found 5168 matches