Hi, i am using oracle 10g database as source and target. i am trying to load data from stage to dimension, but i cannot get correct data to the target table. example Flex_Value_id 56955 56956 56957 56958 56959 56960 56961 56962 56963 56964 56965 56966 56967 56968 56969 56970 56971 while loading this to target i am not getting correct data example i am getting like this 56955 56956 56957 56958 56959 960 56961 56962 56963 56964 56965 56966 56967 56968 56969 970 56971 the source and target datatype is also same. can anyone give the solution for this senthil