I have encountered a weird problem in SAS Data Integration Studio.
I do an extract transformation to extract a subset of the source table and this is loaded to a temporary table.
Whenever, I change something to the job, my extract transformation will extract all the data columns on top of the the selected columns I have choosen. Then I need to delete the unwanted columns away manually.
Is there a way to solve this problem? I personally find it weird because it is also tedious to do that everytime i made a change to the job.