Combining Data with no Specific Key

[Raftsman]

I have dataset that contains fields A,B,C and I want to add D to the dataset. D is a constant that comes from an Oracle sequel statement. Normally I would default it but it come from the database.

Thanks

[DSguru2B]

Via transformer or copy stage you can add an extra column to your dataset. Or better yet, read the value along with a constant dummy key and store it in a lookup file set. Then use the lookup stage and read this value with the dummy key.

[Raftsman]

I added a dummy column to the transformer stage and a dummy column to the Oracle Enterprise stage, used a lookup and voila, I got my added constant column. Where there's a will there's a way.

Thanks

[ray.wurlod]

I hope you exercised great creativity in naming this column!