hi,,
i am very much new to datastage, i am trying to add an extra column to an exisiting columns.. is there any stage with which we can do this.
thanks
Extra column
Moderators: chulett, rschirm, roy
Welcome aboard,
As kris mentioned, solution to your question depends upon where exactly do you want to add a column
If its just a flat file, lookup set or a database; you can go in the columns tab and either manually edit or import
If the source has 4 columns and you want 5 columns in the target (whatever it maybe), just pass it through the transformer, manually edit/add a column or import from a saved schema, to your target and that shall do the trick.
If your quest is any different, then please elaborate your question with specific examples.
As kris mentioned, solution to your question depends upon where exactly do you want to add a column
If its just a flat file, lookup set or a database; you can go in the columns tab and either manually edit or import
If the source has 4 columns and you want 5 columns in the target (whatever it maybe), just pass it through the transformer, manually edit/add a column or import from a saved schema, to your target and that shall do the trick.
If your quest is any different, then please elaborate your question with specific examples.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 25
- Joined: Mon Sep 19, 2005 11:32 am
As mentioned, you can just go in and manually insert a column. Or if you have that particular column saved somewhere, just import it by hitting the Load Column Definition button (a block with a red arrow facing right) inside the transformer.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 36
- Joined: Thu Sep 01, 2005 5:44 am
- Location: Canada