Can we run two separate flows to a single target

[balu124]

Hi ,

can we have a job design which contain multiple flows disigned separatly (no link between the flows)

writing data into a single target .

We take different instances for the same target (one target instance for one flow)

and specify the orderof loading data to target ,is there any option as targetloadplan in informatica?

[ArndW]

Yes.

What is your target? are the two flows in the same job?

[ray.wurlod]

Maybe. Probably.

But not if the two flows are occurring simultaneously and writing to the same sequential file. This is an operating system restriction, not a DataStage restriction. One writer, or N readers.

And you may run into locking (deadlock) issues if you are trying to insert the same keyvalues, especially in arrays or multi-row transactions, from the two or more source links.

[balu124]

[quote="ArndW"]Yes.

What is your target? are the two flows in the same job? ...[/

hi Arndw,
Target is a dimention table in oracle database,thedata is loaded into target from one source table and a sequential file .Each output stream has it 's own calculations(different). There is no link or relation between these two flows.

Constraint is the datafrom file should be load first then data from table

My question is like informatica ,shall we design a job in a single window or two jobs have to be designed separatly and create a batch or a sequencer?
And is there any option like Targetload plan - which tells the order of execution as in informatica

[ArndW]

If you design both "flows" in one job and link the two flows together you have control over the ordering. Likewise, you can design 2 jobs and control them through a job sequence to control ordering. The first option can be made more efficient, but the second is simpler to write and maintain.