Search found 37 matches

by DSShishya
Thu Aug 16, 2012 6:19 am
Forum: General
Topic: Is there a way for us to name the DSJOBREPORT file?
Replies: 8
Views: 3312

Please forgive my ignorance but..... How do I do that?
by DSShishya
Wed Aug 15, 2012 4:16 pm
Forum: General
Topic: Is there a way for us to name the DSJOBREPORT file?
Replies: 8
Views: 3312

Hi Ray,

Are you saying that I can rename the file within the after job routine command prompt or manually later?

Thanks
by DSShishya
Wed Aug 15, 2012 1:41 pm
Forum: General
Topic: Is there a way for us to name the DSJOBREPORT file?
Replies: 8
Views: 3312

Is there a way for us to name the DSJOBREPORT file?

Hi all,

I'm using the DSJobReport in after job routine to get all the job details. Now here the DataStage names the report file by itself as JobName_YYYYMMDD_HHMMSS.txt. Is there a way for me to give the report a name of my choice?

Any help is greatly appreciated.

Thanks.
by DSShishya
Tue May 22, 2012 2:55 pm
Forum: IBM QualityStage
Topic: Complex Survive Expression
Replies: 2
Views: 3251

Thanks Robert!

At first glance, looks like it works. I need to do some more testing tho.

I will update the post.

Thanks again.
by DSShishya
Tue May 22, 2012 10:13 am
Forum: IBM QualityStage
Topic: Complex Survive Expression
Replies: 2
Views: 3251

Complex Survive Expression

Hi all, I have always used out of box survive rules in QS and now need some help with "Complex Survive Expression" in Survive stage. My requirement is to give priority to records source wise. e.g. If there are three records of same customer from 3 different sources SRC1, SRC2 and SRC3 (all...
by DSShishya
Fri Sep 17, 2010 1:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Connector Stage
Replies: 6
Views: 4190

I'm having similar issues....
by DSShishya
Tue Sep 14, 2010 1:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Instance
Replies: 3
Views: 2118

Thank You :D
by DSShishya
Tue Sep 14, 2010 12:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Instance
Replies: 3
Views: 2118

Instance

Hi all,

Can anybody tell me what does 'Instance' mean in the connection property in the Dn2 Connector stage of parallel extender?
by DSShishya
Fri Sep 03, 2010 2:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL Logic in Datastage
Replies: 14
Views: 11279

Got lost in the crowd I guess :lol:
by DSShishya
Thu Aug 26, 2010 2:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer Incorrect Calculation.
Replies: 14
Views: 6270

I'm not very sure about this, but maybe if you use @NULL instead of '' that might solve the problem.
by DSShishya
Thu Aug 26, 2010 12:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup on a sequntial file
Replies: 2
Views: 1468

anbu wrote:Yes you can do
Thanks!!
by DSShishya
Thu Aug 26, 2010 12:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup on a sequntial file
Replies: 2
Views: 1468

Lookup on a sequntial file

Hi all,

Just a simple question. Can we perform lookup in a parrallel job with the reference data on a Sequential file and not on a Lookup FileSet or a table?
by DSShishya
Sun Jul 25, 2010 12:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Maximum Record Limit For lookup stage
Replies: 11
Views: 10350

Re: Maximum Record Limit For lookup stage

Lookup stage can handle any number of records. There is no limit to that. A general threshold of 1 million records is set just to be on the safer side for performance reasons. It mainly depends on the resource allocated to the server machine, memory in particular. Talk to the admin and find out what...
by DSShishya
Sun Jul 25, 2010 10:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Type of partitioning
Replies: 3
Views: 1944

Like Srinivasalu pointed Hash partitioning is key based partitioning. Now in order for you to give better explanation (I suppose this is an interview question) Hash partitioning is used in stages like Aggregator, Remove Duplicate or any of the stages where similar records needs to be in the same par...
by DSShishya
Fri Jul 23, 2010 1:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: splitting sub records!!!
Replies: 5
Views: 3500

Re: splitting sub records!!!

I'm sorry, that would be the "Field" function, not the Index.