The source field consists of 80 characters , and I need to place this whole information in target field which consists of 40 characters in size .......
what transformation or what stages do I need to use?
thank you.
what transformations do I have to do?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 15
- Joined: Sun Feb 22, 2009 3:31 pm
Re: wat transfermations i have to do?
If your source consists of data more than 40 valid characters its most likely to be truncated.. all you can do is remove the leading and trailing spaces using a tranformer..or change the target table definition to hold 80 characters ( this would be the intelligent approach)vikramkola wrote:can any one explain me....
the sourse field consistis of 80 charecters ,and i should place this whole information in target field which consists of 40 charecter in size .......
what trans formation or what stages i had to use ?
thanku.
Regards,
Ganesh
Ganesh
-
- Premium Member
- Posts: 15
- Joined: Sun Feb 22, 2009 3:31 pm
I'm trying to determine if you are having language difficulties or are just completely inexperienced. You can't fit a larger text string into a smaller text string without some sort of data loss or truncation, it is a physical impossibility.
Even if you used an external stage and some sort of external data compression tool, the result would NOT be text. Trimming the text to remove all the extra spaces would also NOT guarantee that the larger string would fit into the smaller string, nor would you be able to "rebuild" the original string.
DataStage isn't "magic" - go back to the people asking you to do this and ask them how they think this can possibly occur.
Even if you used an external stage and some sort of external data compression tool, the result would NOT be text. Trimming the text to remove all the extra spaces would also NOT guarantee that the larger string would fit into the smaller string, nor would you be able to "rebuild" the original string.
DataStage isn't "magic" - go back to the people asking you to do this and ask them how they think this can possibly occur.
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore