Automatic way to integrate the Feed's from source system

Ashish · Participant Joined: 31 Jan 2006 Posts: 57 Points: 487

Hi,

I would like to integrate around 30 inbound feeds coming from 10 source systems through datastage, The file types are excel, csv , text and rdbms, can anyone suggest the best way to integrate such diversed feeds through DataStage without any manual intervention and also suggest the dynamic method i can implement in datastage (If feeds increased in future minimal change is required).

Thnks
Aisi

ray.wurlod · Posted: Thu Oct 16, 2008 1:27 am

How do you know when one of these feeds is ready? That is, what would trigger DataStage processing?

Ashish · Participant Joined: 31 Jan 2006 Posts: 57 Points: 487

ray.wurlod wrote:

How do you know when one of these feeds is ready? That is, what would trigger DataStage processing? ...

There is one Trigger file called X.X ones it appear in the directory, DataStage Jobs kick off.

Let me know if you need more information.

ray.wurlod · Posted: Mon Oct 20, 2008 2:36 pm

No, that's sufficient. Use a Wait For File activity in a job sequence that waits for the trigger file to appear, then whatever else you need is downstream of that in the job sequence.