DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 424 matches
Author Message
Resolved
 Topic: Lookup Stage
meena

Replies: 6
Views: 3400

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 14, 2007 1:22 pm   Subject: Re: Lookup Stage
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 ...
Resolved
 Topic: DerivationStatement
meena

Replies: 3
Views: 1244

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 14, 2007 1:19 pm   Subject: Re: DerivationStatement
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 ...
Resolved
 Topic: which stage to use
meena

Replies: 6
Views: 1754

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 14, 2007 1:13 pm   Subject: Re: which stage to use
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 al ...
 Topic: Issue with timestamp
meena

Replies: 16
Views: 6378

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Jul 10, 2007 1:24 pm   Subject: Issue with timestamp
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 Confused .... As suggested by Craig I will ask m ...
 Topic: Issue with timestamp
meena

Replies: 16
Views: 6378

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Jul 10, 2007 12:39 pm   Subject: Issue with timestamp
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 ...
 Topic: Issue with timestamp
meena

Replies: 16
Views: 6378

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Jul 10, 2007 12:32 pm   Subject: Issue with timestamp
Hi Hemant,
This is happening only for 23:00:00.The remaining timestamp fields looks good.


Does it add 1 hour to every source date ?? or are you having problems only with 23:00:00 time value ??
 Topic: Issue with timestamp
meena

Replies: 16
Views: 6378

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Jul 10, 2007 8:14 am   Subject: Issue with timestamp
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_D ...
 Topic: Issue with timestamp
meena

Replies: 16
Views: 6378

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Jul 09, 2007 9:02 am   Subject: Issue with timestamp
Hi Craig,
I have generated SQL on both ends with timestamp datatype.

Timestamp datatype all the way through? Generated sql at both ends? ...
 Topic: Issue with timestamp
meena

Replies: 16
Views: 6378

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Jul 09, 2007 7:49 am   Subject: Issue with timestamp
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 ...
 Topic: Issue with timestamp
meena

Replies: 16
Views: 6378

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Sun Jul 08, 2007 6:49 pm   Subject: Issue with timestamp
DataStage® Release: 7x
Job Type: Server
OS: Unix
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 th ...
 Topic: Start loop and End Loop in sequencer
meena

Replies: 9
Views: 9227

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Jun 26, 2007 11:44 am   Subject: Start loop and End Loop in sequencer
Thank you DSGuru2B and Craig..

I used the expression given by Craig and it is working.
 Topic: Start loop and End Loop in sequencer
meena

Replies: 9
Views: 9227

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Jun 26, 2007 9:26 am   Subject: Start loop and End Loop in sequencer
DataStage® Release: 7x
Job Type: Server
OS: Unix
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 n ...
Resolved
 Topic: Executing Unix script from routine...
meena

Replies: 3
Views: 1267

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue May 15, 2007 9:36 am   Subject: Executing Unix script from routine...
Thanks a lot...

The routine is working , the error is because of the space.
Resolved
 Topic: Executing Unix script from routine...
meena

Replies: 3
Views: 1267

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue May 15, 2007 7:58 am   Subject: Executing Unix script from routine...
DataStage® Release: 7x
Job Type: Server
OS: Unix
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=" ...
 Topic: Carriage Returns...
meena

Replies: 3
Views: 1292

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed May 09, 2007 7:27 am   Subject: Carriage Returns...
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..
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours