Search found 189 matches

by ady
Thu May 03, 2007 1:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writing to the same file in the same job
Replies: 13
Views: 5315

Yup ...Yup ..... got it now..... was confused earlier, because I have a few job which depend on that design :shock: :wink:
by ady
Thu May 03, 2007 1:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writing to the same file in the same job
Replies: 13
Views: 5315

I have a server job , the design is


Transformer------seqfile----------Transformer---------Seqfile(the same file)

It works fine, Is it not possible in parallel only ?
by ady
Thu May 03, 2007 12:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writing to the same file in the same job
Replies: 13
Views: 5315

Wouldnt a job write to the same sequential file twice, if there is a delay between the two write operations ?

If the file is not written to in the same active stage ?
by ady
Wed May 02, 2007 1:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing non-alphanumeric characters using Convert function
Replies: 9
Views: 10682

ray.wurlod wrote:You will need a routine or a BASIC Transformer stage.
Ray , How can we do it in basic transformer without a routine ?
by ady
Tue May 01, 2007 10:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Got certified in Datastage
Replies: 40
Views: 18552

I can feel the rush back on again .... :evil: Gotta take the test .... :evil: Gotta take the test ... :twisted:
by ady
Tue May 01, 2007 9:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Got certified in Datastage
Replies: 40
Views: 18552

Test 415: IBM WebSphere IIS DataStage Enterprise Edition v7.5 Test 415 Objectives Test 415 Sample test Test 415 Recommended educational resources Approximate # of questions: 79 Duration in minutes: 105 Required Passing Score: 75 Do they mean 75% or 75/79 questions ? ... :? If its 75/79 questions, M...
by ady
Mon Apr 30, 2007 3:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Got certified in Datastage
Replies: 40
Views: 18552

I poked around in the IBM website, this is the so called IBM "sample test" on the website. Most of the sample questions look obvious to me, if the test going to be like this ...... i wouldnt mind taking a quick shot at it ... Think they posted simple questions to get impulsive heads like m...
by ady
Mon Apr 30, 2007 3:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Someone should create a uv/dssh primer or How-To manual
Replies: 9
Views: 2622

I would like to see that happen too...... :wink:
by ady
Wed Apr 04, 2007 1:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: "Keys" and "Values" in Change Capture
Replies: 3
Views: 1345

Hmm... Thanks Ray ....

That makes more sense to me ... :)
by ady
Tue Apr 03, 2007 9:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: "Keys" and "Values" in Change Capture
Replies: 3
Views: 1345

Can anyone explain me the difference between a "key" and a "Value" in a Change Capture stage ? ( apart from getting the result change code as "insert", "Delete" or "Edit" )
by ady
Tue Apr 03, 2007 8:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: "Keys" and "Values" in Change Capture
Replies: 3
Views: 1345

"Keys" and "Values" in Change Capture

Hi, I am comparing 2 files which apparently have the same data. But when I mention a specific column SHIP_TO as a "value" the rows come up as "edited". When I mention the same SHIP_TO as a "Key" the rows show as "COPIES" not "inserts". If the data in...
by ady
Thu Mar 29, 2007 4:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential file outputs Twice the number of rows it has !
Replies: 7
Views: 1989

The routine moves the output file when the job is a success to a different location. I have checked if the script is appending to the previous version of the file, but its not. Its moving the file and replacing the old one as its supposed to do. There are no new line characters in the file. I have c...
by ady
Thu Mar 29, 2007 3:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential file outputs Twice the number of rows it has !
Replies: 7
Views: 1989

The data comes from a script, The script gives out the record count in the last row of the data which is rejected, I actually extract the record count and write it in different sequential file. The job actually has a after job subroutine !! The process compares the "count from the script" ...
by ady
Thu Mar 29, 2007 2:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential file outputs Twice the number of rows it has !
Replies: 7
Views: 1989

I am overwriting the file ..

I am able to view the data properly. My job design is



Seq file > Transformer > Seqfile


The transformer has a constraint which does not allow blank rows to pass. Thats it !
by ady
Thu Mar 29, 2007 12:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential file outputs Twice the number of rows it has !
Replies: 7
Views: 1989

Sequential file outputs Twice the number of rows it has !

Hi,

I have a server job which writes 1249149 rows to a sequential file.
When the same file is used as an input in another job it outputs 2410220


I dont understand why this is happening, I tried this file out in a parallel job, In that case also it gives out 2410220 rows.


Please help