Hello ,
I'm loading data from flatfile to database.
While this process i need to elimate all null records.
The null records which are elimated need to be written to a text file . and other records need to be loaded in the database table.
Can some one help me how to handle this issue.
Thanks,
Kanth.
Hi,
The easiest way to handle this is probably to have two deliveries from your build - the first configured as a text file delivery, and the second as a relational table delivery. Add an output filter to the text file delivery containing syntax such as
Field1 is null and Field2 is null and Field3 is null and... (substituting the real field names for Field1, Field2 etc)
then check the 'Exclusive' checkbox for this delivery.
The build should then deliver the null records to the text file and the non-null records to the relational table.
Hope that helps!
MF.
Thank you , it worked..