DSXchange

Hi All,


Can i have a sequential stage with multiple input links ?

Can are OCI stage have multiple input links to the same table with different update options for each link .

Please clarify me,

Thank you all,

Multiple write links to a sequential stage are possible, but only if each link has a different sequential file to write to.

Multiple write links to a table are possible.

Thanks Arnd for your answer,

But what is the advantage of having single sequential stage but writing to different files for each link , over writing to different files with multiple sequential stages.

Thank you all for your time and help,

Adding to point to the previous post ,


can i have different metadata in each file it is writing but to one sequential stage.

Thank you all again,

Yes, offcourse you can have different metadata for each file you are writing to even though you are using one sequential stage. It's exactly same as we write to a database with multiple links. You need to select the proper input name in the drop down list and load the corresponding metadata.

About the advantages, well when we write to a table in a database, (say for example, SQL server), using a single stage avoids locks.

But in sequential file stage I don't see any other advantage rather than have less number of stages on the designer board.

LogicDude,

uncluttering the desktop is the only effect that I can think of.

In older releases of DataStage, the directory was a stage property and only the file entry name was a link property, so you needed separate Sequential File stages for each separate directory.

This is no longer the case.

Even so I prefer still to use separate Sequential File stages, because I tend to document things thoroughly - so I can put an Annotation beside each where required. "This file contains input records rejected because the Location Code is not on file." Even managers (PHBs) can understand.