Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Handling of NULL values in data flow
Go
New
Search
Notify
Tools
Reply
  
Handling of NULL values in data flow
 Login/Join
 
<Vaibhav Nimavat>
posted
I have made one flow with the source and target both are SQL Server database.It is requirement that if the target contains the row coming from the source is same then it should be rejected.It is done with the row containing some values,but it can't identify the null values in the target and source as the same and insert it twice and more. How can i compare the NULL values as same? So it will not insert many times.Looking forward to answers.

Thanks,
Vaibhav
 
Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Try adding logic to omit the compare if both the source and target columns are NULL. This can be done using the IS MISSING in the calcualtor.
 
Posts: 176 | Location: Desplaines | Registered: August 05, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Handling of NULL values in data flow

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.