Delimiter in Sequential File

ankita · Post by **ankita** » Tue Jan 12, 2010 1:33 am

Hi,
Is it possible to add more than one delimiter in a target sequential file in Server job?

ray.wurlod · Post by **ray.wurlod** » Tue Jan 12, 2010 1:34 am

Not in the Sequential File stage.

You can build the entire line in an upstream Transformer stage and write a single, large VarChar column to the file.

ankita · Post by **ankita** » Tue Jan 12, 2010 1:53 am

But Our requirement is:

1. First Load data in to a sequential file with delimiter '||'.
2. After that other team will be using that sequential file to load into a target table.

If we do this in the transformer stage then is it possible to do the above stages.

Can some help me on this.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 12, 2010 2:51 am

Why not simply remove the (apparently stupid) requirement for a two-character delimiter? Use a non-printing character, such as Ctrl-Y (represented in DataStage as 025).

While you can use the Transformer stage as I mentioned above, the other team will have to jump through similar hoops to unpack the data you have created.

kandyshandy · Post by **kandyshandy** » Tue Jan 12, 2010 12:46 pm

When you map the derivation for each column in the transformer, you can do something like this

Link.ColumnName : '||'

You need not do this for the last column derivation.

And then specify that the delimiter in sequential file as nothing. You may want to adjust your metadata definitions accordingly for the seq file.

OR, as Ray suggested, go for a single character delimiter.