DSXchange

Join / Merge stage. I have a requirement that needs to retrive the data from the source where the lookup is not matched. Suppose if source have the 10 records and look up has the 3 matched records remaining 7 unmatched records should be taken forward to Output link. What i am doing is i taken normal...

If (AAA = 255 & BBB<0) Then 'LOSS' Else If (AAA = 255 & BBB >0) then 'PROFIT' Else ' ' AAA, BBB my target field name is: XXX The logic to populate XXX target column like below: if AAA = 255 ( BBB<0 THEN populate XXX= LOSS,but IF BBB >0 then populate XXX=PROFIT) Else other than AAA=255 VALUES...

Hi Prasad, If col1 values are consistent( 'M','C' & 'U'). Use the transformer stage to filter the col1 using constarints and to get three output streams.Define a common dummy column in all three outstreams with the same constant value.Next use the merge stage to merge all the three streams. Or y...

Hi DSguru2B, The date got added by one. Ex: 07-01-2007 00:00:00 (In SQL tool) 07-02-2007 00:00:00 (In DS) Not understanding what's going on :? .... As suggested by Craig I will ask my lead to check with the offical support provider... Strange and beats me. Try providing TRUNC(Field_date) in the deri...

Hi DSguru2B, I am facing this issue in Datastage,outside the datastage when I run the same SQL then I am able to see the timestamp Ex: 07-01-2007 23:00:00 (In Sql tool) 07-02-2007 00:00:00 (In DS) For the same SQL. I tried, by changing the datatype to Varchar.But no use I am getting the same round u...

Hi Hemant,
This is happening only for 23:00:00.The remaining timestamp fields looks good.

Hemant_Kulkarni wrote:Does it add 1 hour to every source date ?? or are you having problems only with 23:00:00 time value ??

Hi DSguru2B, I run the query in SQL tool and I am not getting any output. In your favourite sql tool, run the following query on your date field. SELECT Field_Date,dump(Field_Date) FROM YourTable WHERE Field_Date != Field_Date+0 This is to check if your date is infact corrupted or not. The corrupted...

Hi Craig,
I have generated SQL on both ends with timestamp datatype.

chulett wrote:Timestamp datatype all the way through? Generated sql at both ends? ...

Hi All, I am running the same SQL outside the DS and I am able see the time in the field data. Ex: Source : Field_Date Value: 07-01-2007 23:00:00 And the target field is timestamp too but the field value is getting round up to 07-02-2007 00:00:00.. For testing purpose I designed a new job to load th...

Hi All, I am extracting data from an oracle database table and loading into other oracle database table.(Using DRS stage). I have an issue with timestamp field. While extracting the data from the table the date fields of the table are selected as timestamp. Ex: To_Char(Field_Date,'YYYY-MM-DD HH24:MI...

Thank you DSGuru2B and Craig..

I used the expression given by Craig and it is working.

Hi All, I have to handle multiple files to be loaded into an oracle.Has there is job dependencies , I designed a sequencer to handle multiple files. But for some reason the designed sequencer is not working for multiple files. Files Type: YUR30120070607.001, YUR30120070619.003 etc. Sequencer design:...

Thanks a lot...

The routine is working , the error is because of the space.

Good Morning All, I wrote a routine to execute UNIX script. As I need the ouptut of the UNIX scirpt, I wrote a new routine instead of using the 'Execute Command' in the sequencer. Command="ksh +x" : Arg: "/InputFilesCount.sh" Call DSExecute("UNIX",Command, Output, Syste...

Hi Nick,
We are FTP'ing the files in the ASCII mode & In Stage tab of sequential file we used Line Termination to DOS Style..