I've got a simple job i am creating and it involves conversion of a Numeric(14,0) to an Integer(10). Can i make this implicit conversion in a copy stage? I am working with whole number values with six digits. My job is running correctly but I am trying to understand if the copy stage can convert implicitly without using a function. If i dont end up using the copy stage i will be using the modify stage or a transformer stage, but i figured the copy stage would use the least system resources to process.
Thanks in advance and forgive my ignorance!
Simple question about copy stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 53
- Joined: Fri Apr 18, 2008 8:13 am
- Location: United States
Simple question about copy stage
Hi Jag,
You cannot achieve this using a Copy Stage because down the line it will create issues.
You cannot achieve this using a Copy Stage because down the line it will create issues.
Regards
Ajay
Ajay
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can achieve any implicit conversion with any stage type that supports input and output links.
Note, however, that Numeric(14,0) does not implicitly convert to int32. Either use int64 on the output or Numeric (9,0) on the input.
Note, however, that Numeric(14,0) does not implicitly convert to int32. Either use int64 on the output or Numeric (9,0) on the input.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am