sivarao

 Profile Answers by sivarao Questions by sivarao

• Dec 28th, 2005

 

Check for Parameters.

and check for inputfiles are existed or not and also check for input tables existed or not and also usernames,datasource names,passwords like that

qwert123

 Profile Answers by qwert123 

• Jul 1st, 2009

 

Hi, I worked on a process which was loading target table after performing email standardization on source files.
I performed the following validations:
1)all letters should be in smallcase
2)email id field should not contain more than 255 characters
3)it should not contain special characters except underscore

While loading sometimes i came across to the following errors:

1)"unknown field name....." because metadata was not properly loaded..i reloaded the data and it worked fine...

2)"data truncaion warning"..bcoz in data stage data type size was less than the size of data type in database