DSXchange

Hi All, I want to validate Longitude and Latitude and was tired with below , but seems like it didn't work properly IF Trim(NullToEmpty(DSLink108.LONGITUDE)) >= -180.00000000 OR Trim(NullToEmpty(DSLink108.LONGITUDE)) <= +180.00000000 THEN 0 ELSE 1 IF Trim(NullToEmpty(DSLink108.LATITUDE)) >= 90.00000...

There will be one row for each month

Hi All, Can you please help me with the logic for the following requirement INPUT: ID | MM Number | From | To 12345|4444444|2015-01-03|2015-02-02 12346|4444444|2015-02-03|2015-03-02 << missing one record ( ex same MM Number no record for period from 2015-03-03 to 2015-04-02 12347|4444444|2015-04-03|...

Hi All, I'm using the dsjob command to run the datastage job and I want to check periodically job is running or not using dsjob command If I use below command if the job i running or finished returns 0 DSLOGMSG=`$DSHOME/bin/dsjob -jobinfo ud_1245 FH_P_EXTRACT_DELTA|head -1|sed 's+[^0-9]++g'|tr -d '\...

Below SOQL returning null value from Salesforce stage, but if I run the same SOQL in Salesforce Developer console I'm getting the value.

Select max(LastModifiedDate) From POI__c p

Does that DataStage Salesforce stage connector support SOQL like above?

Appreciated your help on this.