Search found 194 matches

by dsscholar
Fri Nov 04, 2011 7:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mount points for scratch disk and resource disk
Replies: 5
Views: 2801

Mount points for scratch disk and resource disk

Hi There,


Is Necessary to have the seperate mount points for scratch disk and resource disks?

will it effect performance if we define all resource and scratch disk in the same mount point?

Please give some suggestions

Thanks
by dsscholar
Thu Nov 03, 2011 9:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer lookup
Replies: 16
Views: 6491

Thanks for your timely help jwiles. Will try it out today.
by dsscholar
Thu Nov 03, 2011 1:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer lookup
Replies: 16
Views: 6491

i dont know what value to give as each column will be having different different lengths Are you saying that the width of these non-delimited columns may change from record to record, and they happen to add up to 50? Is there anything within the record which can indicated what the widths actually a...
by dsscholar
Thu Nov 03, 2011 10:45 am
Forum: General
Topic: text file to parameter file
Replies: 3
Views: 2852

Re: text file to parameter file

I dint know that chulett. thanks anyway!!
by dsscholar
Thu Nov 03, 2011 10:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer lookup
Replies: 16
Views: 6491

BI-RMA, i mentioned varying column widths and not varying record length. Eg : Total length : 50 ten columns not with equal length 5 forms the 50. one will be with 3,other with 7 like that. And source wont be having any field delimiter then how to specify the delimiter in case of column import stage ...
by dsscholar
Thu Nov 03, 2011 10:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer lookup
Replies: 16
Views: 6491

BI-RMA, i mentioned varying column widths and not varying record length. Eg : Total length : 50 ten columns not with equal length 5 forms the 50. one will be with 3,other with 7 like that. And source wont be having any field delimiter then how to specify the delimiter in case of column import stage ...
by dsscholar
Thu Nov 03, 2011 10:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer lookup
Replies: 16
Views: 6491

Hi all,

No header in the sequential file. New line is the record delimiter.

And in case of using transformer, i dont find a function corresponding to substr. Can u please help me in that.

Thanks in advance
by dsscholar
Thu Nov 03, 2011 9:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer lookup
Replies: 16
Views: 6491

Hi ray,

The column width will be varying. As u suggested, it should be fixed right.. How to proceed in case of varying column widths

jwiles,

How to use column import in case of varying column widths..

ThankS in advance
by dsscholar
Wed Nov 02, 2011 12:43 pm
Forum: General
Topic: text file to parameter file
Replies: 3
Views: 2852

text file to parameter file

Hi all, For incremental extraction from the source, i go for parameter file concept. 1) First i load start_date and end_date to a text file. 2) Then from text file to parameter file(via sequencer execute command activity) This s the process i generally follow. I change it to a string and load it to ...
by dsscholar
Tue Nov 01, 2011 9:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer lookup
Replies: 16
Views: 6491

Thanks guys.

Record delimiter is newline. I will try both the ways and let u know.
by dsscholar
Tue Nov 01, 2011 1:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: transformer lookup
Replies: 16
Views: 6491

transformer lookup

please explain lookup


Please clarify. Thanks in advance.
by dsscholar
Tue Nov 01, 2011 8:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Count of parallel instances that are running
Replies: 1
Views: 1396

Count of parallel instances that are running

Hello, We have to write a multi-instance job that should be triggered based on a run-time parameter. So if at run time we want the job to run for 2 subscribers, it should be triggered 2 times parallely, however if this count it more than 5, then we want to queue up the jobs. So the first 5 jobs shou...
by dsscholar
Tue Nov 01, 2011 7:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot find a 'job started' record in job log
Replies: 3
Views: 3489

Its pop-up window in director logview while trying to view the log,Job is just trying to copy one file to a dataset.It is the first time we are using this server.
by dsscholar
Tue Nov 01, 2011 7:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot find a 'job started' record in job log
Replies: 3
Views: 3489

Cannot find a 'job started' record in job log

Hi There

we are able to compile the jobs successfuly ,not able to run ,its prompting the warning message like "Cannot find a 'job started' record in job log",in director also its showing compiled ,not chaning to running status

Please give me a suggestion


Thanks
by dsscholar
Wed Oct 19, 2011 1:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Record delimiter string vs final delimiter string
Replies: 4
Views: 4062

Theoritically it makes some sense. Final delimiter string : at the end of the last column Record delimiter string : at the end of the record. Practically both are same only right. At the end of the record and at the end of the last column in each record. Please explain with one sample. Thanks in adv...