DSXchange

Hi,
There are already few posts on the same context. Please search it in the forum.

Try Having "Custom Conditional" Trigger and check the JobStatus = 'Finished Ok' for SUCCESS Else GoTo Failure Link

Hi,

Add a parameter to your job properties and you will be able to pass your schema file name to it at run time.

Hi, If you are sourcing from a Sequential File, goto the file properties tab where you will find a DATE sub-tab. Browse that tab and you will find ' FORMAT ' option. If you click it, you will be able to see the format of your date field. By default it is ' mm/dd/yyyy '. You can change this format to...

Hi, In a Job Sequence you have something called as a " SEQUENCER " activity. In this sequencer activity, you can set ' ALL ' or ' ANY ' representation. Try using this. Set the ' ANY ' property and link all your ' WAIT FOR FILE ' activities to this sequencer activity with ' ANY ' set in it....

Hi,

Your DATA basically contains "DATE" values and your aggregator gets your output in "DOUBLE" data type. So convert your DATA column to a format compatible with DOUBLE data type and then try using Aggregator.

Apart from unchecking the box 'ensure all char fields to be unicode', while loading metadata into any stage, you can also use a COPY stage and get rid of all those "UNICODES".

Hi,

As Nagarjuna rightly said, unless you make any changes (Metadata Change) to your dataset in the first job, you can always go ahead and use it for the specified number of columns you want in the next successive jobs.

Try out this particular check. In your Transformer define a "FLAG" in your Stage Variable and perform this check in your Stage Variable "If IsValid('date', EFF_DT) Then "Y" Else "N". Based on this Flag value, you can proceed further to either process the record or ...

Sorry guys....will definitely keep it in mind.....

Hi, U cannot directly use MAX() in $CommandOutput. If dis is wat u r doing, den its wrong. If gettin MAX value is wat ur requirement all about, den try fetchin it at ur UNIX lvl interface b4 performin it at DS lvl. Once u 've ur MAX value frm UNIX, den u can go ahead n use it in ur job usin a Comman...

use Abs() or Ceil() to solve your issue

i would like to go with tables coz its easy to identify ane kind of data issue with the help of a query.......in datasets its difficult to identify these data issues........but finally it depends upon ones requirements to have a dataset or a table.........

i would like to go with tables coz its easy to identify ane kind of data issue with the help of a query.......in datasets its difficult to identify these data issues........but finally it depends upon ones requirements to have a dataset or a table.........

you cannot pass job parameter to buildop.........its a pure c++ code.......

you cannot pass job parameter to buildop