Hi,
Also there may be a mismatch b/w partiton key, sort key and join key....
which means records are kept in memory for long waiting for a matching record.
Search found 86 matches
- Wed Aug 02, 2006 2:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: job failed : Output file full, and no more output files
- Replies: 5
- Views: 12832
- Fri Jun 16, 2006 1:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: re: occurs 0-200 times depending on clause in CFF stage
- Replies: 2
- Views: 1583
Re: re: occurs 0-200 times depending on clause in CFF stage
Hi panic,
indexed columns in cobol file is not supported by Datasate CFF.
Regs
madhukar
indexed columns in cobol file is not supported by Datasate CFF.
Regs
madhukar
- Fri Jan 13, 2006 5:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: passing parameter as group by key to agg.
- Replies: 1
- Views: 762
passing parameter as group by key to agg.
hi all,
i need to pass parameter value to agg grp by key.
it can done by using a transformer by a creating a column and
assigning parameter value to it.
any other way to get the same result?
i need to pass parameter value to agg grp by key.
it can done by using a transformer by a creating a column and
assigning parameter value to it.
any other way to get the same result?
- Fri Jan 13, 2006 5:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Joining 2 Datasets using between logic??
- Replies: 8
- Views: 2573
Re: Joining 2 Datasets using between logic??
ray,
2 options available in lookup
1 lookup on key
2 other than lookup key match , what else condition it has to meet
for the above req, we can give the following expn in lookup condition.
EFFECTIVE_DATE >= BILL_ST and EFFECTIVE_DATE <= BILL_END
2 options available in lookup
1 lookup on key
2 other than lookup key match , what else condition it has to meet
for the above req, we can give the following expn in lookup condition.
EFFECTIVE_DATE >= BILL_ST and EFFECTIVE_DATE <= BILL_END
- Fri Jan 13, 2006 4:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning in Funnel stage
- Replies: 9
- Views: 6302
Re: Warning in Funnel stage
u will get RCP option in output/columns page
- Fri Jan 13, 2006 2:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Joining 2 Datasets using between logic??
- Replies: 8
- Views: 2573
Re: Joining 2 Datasets using between logic??
[quote="MarkStewart"]I've created the 1st data set where I've left the FIN_YEAR and FIN_MONTH columns blank. The EFFECTIVE_DATE has a date value on the same dataset. I've created a 2nd data set with FIN_YEAR, FIN_MONTH, BILL_ST, BILL_END. How do I join the two datasets? I need to get the F...
- Mon Jan 09, 2006 6:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ~~~Warning in job~~~
- Replies: 11
- Views: 5912
- Thu Sep 01, 2005 8:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COMPILATION ERROR
- Replies: 3
- Views: 1675
COMPILATION ERROR
hI all i AM GETTING THIS ERROR DURING COMPILATION, #E TFAV 000000 09:27:51(002) <transform> When processing argument -inputschemaWhen processing schema: schema contains a field "END_DT" that is a subrec or tagged; only top-level fields are accepted ANYBODY KNOW WHY? REDARDS. MADHU
- Mon Aug 15, 2005 9:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Empty Data Set
- Replies: 3
- Views: 2083
Empty Data Set
hi all,
How to create empty data sets?
And how to clear the existing data in a dataset?
regs
Madhukar
How to create empty data sets?
And how to clear the existing data in a dataset?
regs
Madhukar
- Wed May 25, 2005 4:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: row to column
- Replies: 4
- Views: 2165
- Tue May 24, 2005 6:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: blank rows in the file
- Replies: 6
- Views: 2122
blank rows in the file
hi all
hw to identify and remove blank rows from the source file
hw to identify and remove blank rows from the source file