First Character of source to First char of target
Posted: Wed Jun 14, 2006 6:34 am
Hi All,
My source is a flatfile and target is an OCI,my scenario is I have source column srcCol and corresponding target column TrgCol1
SrcCol1 (Datatype - Char(1)) is moved to column TrgCol1 (Datatype - Char(2))of table .
So srcCol1 should be moved to the first character of column TrgCol1
If I have Data like
srcCol1 -A then the it should populate in Trgcol1 as "A_ " not as "_ A"
I mean source column value should go to the first charcter of the target column not to the second character.
Will The Datastage implicitly take the value in the first character itself or should I need to explicitly put the value only in the first character.
Please suggest
Regards,
Saik
My source is a flatfile and target is an OCI,my scenario is I have source column srcCol and corresponding target column TrgCol1
SrcCol1 (Datatype - Char(1)) is moved to column TrgCol1 (Datatype - Char(2))of table .
So srcCol1 should be moved to the first character of column TrgCol1
If I have Data like
srcCol1 -A then the it should populate in Trgcol1 as "A_ " not as "_ A"
I mean source column value should go to the first charcter of the target column not to the second character.
Will The Datastage implicitly take the value in the first character itself or should I need to explicitly put the value only in the first character.
Please suggest
Regards,
Saik