Page 1 of 1
How Funnel records in Server Job
Posted: Tue Apr 21, 2009 12:50 pm
by dsguy78
I receive data from 3 files and I need to Funnel them and load it to a table.
In parallel job it could have been done by Funnel stage.
I am using server job. Please let me know how it can be done in server job.
*Note: Moved to correct forum - Content Editor *
Posted: Tue Apr 21, 2009 12:54 pm
by Mike
Link collector stage is one option.
Filter in a sequential file stage is a second option.
... and there are probably other ways as well.
Mike
Posted: Tue Apr 21, 2009 1:28 pm
by ray.wurlod
Moderator: please move to server forum
Re: How Funnel records in Server Job
Posted: Tue Apr 21, 2009 11:44 pm
by sharantheboss
Hi,
The best option is using stage Link Collector.
Regards
Boss
dsguy78 wrote:I receive data from 3 files and I need to Funnel them and load it to a table.
In parallel job it could have been done by Funnel stage.
I am using server job. Please let me know how it can be done in server job.
*Note: Moved to correct forum - Content Editor *
Re: How Funnel records in Server Job
Posted: Tue Apr 21, 2009 11:46 pm
by sharantheboss
Hi,
The best option is using stage Link Collector.
Regards
Boss
dsguy78 wrote:I receive data from 3 files and I need to Funnel them and load it to a table.
In parallel job it could have been done by Funnel stage.
I am using server job. Please let me know how it can be done in server job.
*Note: Moved to correct forum - Content Editor *
Posted: Wed Apr 22, 2009 2:27 am
by ray.wurlod
I disagree. Sequential File stage with cat as the filter command is way more efficient than a Link Collector stage.
Posted: Wed Apr 22, 2009 3:27 am
by eostic
Pros and cons to both...the sequential option cannot be used in a real-time job......