I got a very special requirement. I have file with 10 columns with 10mill records
In case if any of the columns is missing or if the file comes with less columns then the wf should be terminated.
Is there any perbuilt option in the Informatica to terminate the process or at least skip the record?
I am not able to see such options
in the iif(COL =' NULL' ,abort('Message')) U mean COL means the column value or column name
if column value means then for 10 mill records performance will go down
i am looking for some inbuilt informatica option that will terminate the wf if it receive a file with less no of columns are more no of columns