Search found 15 matches

by HariD
Mon Sep 20, 2010 12:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Irreconcilable constraints on the number of partitions
Replies: 1
Views: 2913

Irreconcilable constraints on the number of partitions

Hi, I have a single Dataset as my target in one job, when I run it, getting the following error. main_program: Fatal Error: There are irreconcilable constraints on the number of partitions of an operator: parallel APT_DBExportOperator in oraCdmInvoiceIncidentRej. The number of partitions is already ...
by HariD
Thu Jul 01, 2010 6:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential_File_0,0: Field "TRIP_NAME_IDENTIFIER"
Replies: 4
Views: 3245

Sequential_File_0,0: Field "TRIP_NAME_IDENTIFIER"

Im getting this warning when importing source seq file

Sequential_File_0,0: Field "TRIP_NAME_IDENTIFIER" has import error and no default value; data: {T r i p 20 N a m e 20 I d e n t i f i e r}, at offset: 0

Any answer would be appreciated.
by HariD
Tue Mar 23, 2010 4:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to improve the performance of mainframe jobs
Replies: 3
Views: 2085

how to improve the performance of mainframe jobs

Hi,

I have data coming from mainframe systems and we r going to improve the performance of the job (i.e Parallel job),is there logic to apply for improve the performace.


Any answer can be appreciated.
by HariD
Mon Mar 22, 2010 7:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DB2 Vs Hash partition technique
Replies: 4
Views: 2721

DB2 Vs Hash partition technique

I have db2 data so i have to apply partition technique on the data which partititon type gives more performance.
by HariD
Fri Mar 19, 2010 6:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: if moretha 5 merge stages how to improve performance
Replies: 1
Views: 1741

if moretha 5 merge stages how to improve performance

we have more than 5 merge stages? Each havin Auto partition type is ther any other type to improve performance...
by HariD
Fri Mar 19, 2010 6:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to increase the JOIN stage performance
Replies: 2
Views: 3817

How to increase the JOIN stage performance

I have so many JOIN stages in my job then i want to improve the performance of the job.All join stages partition type is Auto is there result while setting the any other partition technique..

Any answer would be appreciated.
by HariD
Thu Mar 18, 2010 5:35 am
Forum: General
Topic: Heap Memory allocation error
Replies: 1
Views: 2244

Heap Memory allocation error

Hi im getting below error

Src_Bdexpdtl,0: Operator terminated abnormally: Terminating with exception:APT_BadAlloc: Heap allocation failed.

Any answer can be Appreciated
by HariD
Thu Mar 18, 2010 3:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unicode Error
Replies: 1
Views: 1606

Unicode Error

i have some columns with the type as unicode and whn loading the data to target database i.e oracle im getting error like UTF-8 to Unicode substring ,can anybody help for this issue...
by HariD
Mon Mar 15, 2010 12:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: what is Sparse lookup and what is Normal look up
Replies: 3
Views: 5957

what is Sparse lookup and what is Normal look up

what is Sparse lookup and what is Normal look up
by HariD
Mon Mar 08, 2010 3:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Changing Meta Data File Format To The Schema File Format
Replies: 1
Views: 1790

Changing Meta Data File Format To The Schema File Format

Changing Meta Data File Format To The Schema File Format
by HariD
Mon Mar 08, 2010 3:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how can I read all three formats from the same sequential fi
Replies: 1
Views: 1833

how can I read all three formats from the same sequential fi

I have one text file with 3 different layouts. content of the file: the first 5 lines contain header information (layout 1) line 6 to 20 contains detail record information (layout 2) line 21 to the end contain trailer information. (layout 3) how can I read all three formats from the same sequential ...
by HariD
Tue Feb 23, 2010 5:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unit Testing
Replies: 3
Views: 7930

Unit Testing

How can we done the Unit Testing on datastage Jobs.[/b]