How Funnel records in Server Job

dsguy78 · Post by **dsguy78** » Tue Apr 21, 2009 12:50 pm

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 *

Mike · Post by **Mike** » Tue Apr 21, 2009 12:54 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Apr 21, 2009 1:28 pm

Moderator: please move to server forum

sharantheboss · Post by **sharantheboss** » Tue Apr 21, 2009 11:44 pm

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 *

sharantheboss · Post by **sharantheboss** » Tue Apr 21, 2009 11:46 pm

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 *

ray.wurlod · Post by **ray.wurlod** » Wed Apr 22, 2009 2:27 am

I disagree. Sequential File stage with cat as the filter command is way more efficient than a Link Collector stage.

eostic · Post by **eostic** » Wed Apr 22, 2009 3:27 am

Pros and cons to both...the sequential option cannot be used in a real-time job......

DSXchange

How Funnel records in Server Job

How Funnel records in Server Job

Re: How Funnel records in Server Job

Re: How Funnel records in Server Job