Data load deletes rows where there are null values
I have loaded some data from my database and realized there was some inconsistencies with the actual numbers. When I investigated further, I realized that all the rows where one of my date variables was null, were deleted. The data load was done with the data load manager, so I did not write a script myself or told it to delete rows with nulls. Does someone have a clue what could be happening and how can I counteract this?
while loading main script you can give condition like
Where your_Field not null ;
Thanks
Vikas
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
