mapping higher to lower length transformer
Posted: Mon May 27, 2013 7:15 am
Hi,
I'm mapping varchar18 to varchar(15) in transformer stage. I'm not using substring here. I'm just doing direct mapping. I have data in length 18 from source. I expected warning in data stage log and this record will get dropped and the job status will be finished with warnings. But it doesn't throw any warning. Transformer stage passed first 15 characters only to target and job status is finished. Is this actual behavior of transformer stage? Do I need to set any environment variable to raise warning and make the record to get dropped from transformer stage?
Thanks,
Poovalingam.
I'm mapping varchar18 to varchar(15) in transformer stage. I'm not using substring here. I'm just doing direct mapping. I have data in length 18 from source. I expected warning in data stage log and this record will get dropped and the job status will be finished with warnings. But it doesn't throw any warning. Transformer stage passed first 15 characters only to target and job status is finished. Is this actual behavior of transformer stage? Do I need to set any environment variable to raise warning and make the record to get dropped from transformer stage?
Thanks,
Poovalingam.