Search found 3329 matches

by Sainath.Srinivasan
Tue Feb 17, 2009 3:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to send an email if file is not found on remote server
Replies: 4
Views: 1381

Why don't you create a dummy version of the file (say with content like 'FILE NOT FOUND') before attempting the FTP.

After the FTP, check the first line of resulting file.
by Sainath.Srinivasan
Tue Feb 17, 2009 3:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-00911 error
Replies: 17
Views: 5608

What happens if you manually do an insert of the same values?

Do you have any other trigger or default values behind the scene?
by Sainath.Srinivasan
Mon Feb 16, 2009 8:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to open text file
Replies: 6
Views: 2358

Something you might have already tried

1.) Copy one of "previous run" files as the new name and try to view
2.) When you "view data", does all required parameter prompts appear?
3.) Is there any special chars in the filename / format section?
by Sainath.Srinivasan
Mon Feb 16, 2009 8:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-00911 error
Replies: 17
Views: 5608

Can you perform the same insert outside ds (i.e. through other client like SQL*Plus?

Identify the offending columns by process of elimination.
by Sainath.Srinivasan
Mon Feb 16, 2009 6:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: date Format YYYYMMDD check
Replies: 10
Views: 2487

Give some example of good and bad values. Also provide the format mask you tried.
by Sainath.Srinivasan
Fri Feb 13, 2009 9:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SERIOUS DESIGN PERFORMANCE ISSUES - WINDOWS
Replies: 9
Views: 3589

DS 8 eats your client PC's memory.

Close ALL other memory consuming process (e.g virus scanner, windows updates) and you will see SOME difference.
by Sainath.Srinivasan
Fri Feb 13, 2009 9:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SERIOUS DESIGN PERFORMANCE ISSUES - WINDOWS
Replies: 9
Views: 3589

DS 8 eats your client PC's memory.

Close ALL other memory consuming process (e.g virus scanner, windows updates) and you will see SOME difference.
by Sainath.Srinivasan
Fri Feb 13, 2009 9:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Max and Min value as input to DB2 stage
Replies: 9
Views: 1824

Create the sql into a file in the pre-job and use external SQL file in the job
by Sainath.Srinivasan
Fri Feb 13, 2009 7:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Capture Reject Records
Replies: 5
Views: 2013

Add a dummy column at the end with "Replace" with blank. If this contains value at any time, reject it in the transformer.
by Sainath.Srinivasan
Fri Feb 13, 2009 3:31 am
Forum: General
Topic: Finding a Input Dataset used in jobs
Replies: 9
Views: 4104

I don't have 7.x, but believe you can do a "Where used" from Manager.
by Sainath.Srinivasan
Fri Feb 13, 2009 3:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash building job running longer than normal
Replies: 5
Views: 1303

Search for static hash files and hash utility.
by Sainath.Srinivasan
Thu Feb 12, 2009 6:40 am
Forum: General
Topic: Appending leading Zeros and writting to excel file
Replies: 9
Views: 2346

Work in csv or txt.

Prefix all with a dummy character so all will be text.
by Sainath.Srinivasan
Thu Feb 12, 2009 5:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance in DS vs Oracle
Replies: 6
Views: 2168

Who said Oracle does not use "Parallelism" ? It may be how you have configured it. Doing in a single query may inturn avoid a transformer or modify stage and thus reducing number of process spawned. Perform few sample tests in oracle and DS to see which is useful. Also check the plan in bo...