Search found 151 matches
- Mon Oct 18, 2010 9:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how remove duplicate in transformer
- Replies: 7
- Views: 4646
You can use the following logic to remove duplicates using the Transformer Stage, however for that you need to have data sorted. Before using the transformer Stage, use Sort Stage to sort the data. In Transformer Stage, take the FirstRecordVar=SecondRecordVar IncomingLnk.Value=FirstRecordVar Then i...
- Sun Oct 17, 2010 12:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator Stage
- Replies: 5
- Views: 3797
Hi Ray, I was just trying to look into aggregator stage scenario I came across and found this post here in the history. Is it true that aggregator stage aborts on last record every time? I don't think so as I have seen running it fine too. May be I am missing something from the statement made above....
- Sat Oct 16, 2010 5:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Range lookup
- Replies: 11
- Views: 4850
- Sat Oct 16, 2010 1:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Substract Business Days
- Replies: 5
- Views: 3646
- Sat Oct 16, 2010 1:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Copy Datasets from old Project to New Porject
- Replies: 3
- Views: 5304
- Mon Oct 11, 2010 4:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup with constraint
- Replies: 14
- Views: 8432
- Mon Oct 11, 2010 2:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup with constraint
- Replies: 14
- Views: 8432
Did you try doing that in a Transformer/Filter stage downstream? yes , so wen lookup on ID only , multiple entries are present in reference table for a ID then only one entry gets picked up and other wont and lookup stage has option to return multilple row only for one reference link. not more for ...
- Fri Oct 08, 2010 11:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: exporting job parameters
- Replies: 4
- Views: 2929
- Fri Oct 08, 2010 11:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: exporting job parameters
- Replies: 4
- Views: 2929
exporting job parameters
Can we export or import job parameters also just like jobs?
- Wed Oct 06, 2010 11:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Enterprise vs Plug in
- Replies: 4
- Views: 3244
- Wed Oct 06, 2010 12:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Enterprise vs Plug in
- Replies: 4
- Views: 3244
Enterprise vs Plug in
Hi,
What is the difference between Enterprise stage and plug in stage? For example FTP enter prise stage vs FTP plug in stage or ODBC Enterprise stage Vs ODBC Plug in?
What is the difference between Enterprise stage and plug in stage? For example FTP enter prise stage vs FTP plug in stage or ODBC Enterprise stage Vs ODBC Plug in?
- Wed Oct 06, 2010 3:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Expand Stage Schema
- Replies: 5
- Views: 4649
- Wed Oct 06, 2010 3:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using FTP Enterprise stage for ftp'ing files
- Replies: 6
- Views: 3503
- Wed Oct 06, 2010 2:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using FTP Enterprise stage for ftp'ing files
- Replies: 6
- Views: 3503
- Tue Oct 05, 2010 11:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: import & export
- Replies: 4
- Views: 3118