Hi,
If I have to concatenate or say insert constant valus in some columns before loading into Oracle , is using the transformer the only option or do we have any light stages than the transformer.
Thanks,
Avoid Concatenate/constants in Transformer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 49
- Joined: Fri Nov 11, 2005 10:19 am
You have a "Generate Columns" stage to add constant values, and I would think that you might be able to do some concatenation in a modify stage, but I'd have to check up on that to make sure (I'm not at a DataStage machine right now - but someone else might correct me before I get to a client workstation tomorrow)
-
- Participant
- Posts: 49
- Joined: Fri Nov 11, 2005 10:19 am
-
- Participant
- Posts: 49
- Joined: Fri Nov 11, 2005 10:19 am
-
- Participant
- Posts: 28
- Joined: Mon Jan 09, 2006 1:31 pm
Hi Aliso,
Even if you want to do the concatenation after several steps, still u can do the hard coding in the source stage itself. In the source stage instead of concatenating there, pass that value as a separate column and at the place where you want to concatenate, there just concatenate the fields.
Even if you want to do the concatenation after several steps, still u can do the hard coding in the source stage itself. In the source stage instead of concatenating there, pass that value as a separate column and at the place where you want to concatenate, there just concatenate the fields.
With regards,
Thiru
Thiru
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: