Lets Suppose We Have Some 10,000 Odd Records In Source System And Whe

1.	Lets Suppose We Have Some 10,000 Odd Records In Source System And When Load Them Into Target.how Do We Ensure That All 10,000 Records That Are Loaded To Target Doesn't Contain Any Garbage Values?
Answer» we can do LTRIM, rtrim in the EXPRESSION or can have CHECK for NULL and then insert the data. we can do ltrim, rtrim in the expression or can have check for null and then insert the data.

Lets Suppose We Have Some 10,000 Odd Records In Source System And When Load Them Into Target.how Do We Ensure That All 10,000 Records That Are Loaded To Target Doesn't Contain Any Garbage Values?

Answer»

we can do LTRIM, rtrim in the EXPRESSION or can have CHECK for NULL and then insert the data.

we can do ltrim, rtrim in the expression or can have check for null and then insert the data.