| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: what are validations you perform after creating jobs in designer.
what r the different type of errors u faced during loading and how u solve them
|
| July 07, 2009 02:46:16 |
#2 |
| qwert123 |
Member Since: March 2009 Total Comments: 7 |
RE: what are validations you perform after creating jobs in designer.what r the different type of errors u faced during loading and how u solve them
|
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 |
| |
Back To Question | |
