Topic
2 replies Latest Post - ‏2012-10-24T17:08:51Z by SystemAdmin
chandulds
chandulds
3 Posts
ACCEPTED ANSWER

Pinned topic Transformer Null Handling

‏2012-08-07T03:32:25Z |
Please let me know which one is correct.

1)
If U_Name " " Then F_Name Else SetNull()

2)
If IsNull( U_Name) " " Then F_Name Else SetNull()
Updated on 2012-10-24T17:08:51Z at 2012-10-24T17:08:51Z by SystemAdmin
  • beach_bum
    beach_bum
    49 Posts
    ACCEPTED ANSWER

    Re: Transformer Null Handling

    ‏2012-08-07T06:51:50Z  in response to chandulds
    Third time lucky, eh?

    https://www.google.co.uk/search?q=ibm+infosphere+datastage+parallel+job+developer+manual
  • SystemAdmin
    SystemAdmin
    7754 Posts
    ACCEPTED ANSWER

    Re: Transformer Null Handling

    ‏2012-10-24T17:08:51Z  in response to chandulds
    Second option but remove the quotes. See below:

    If
    IsNull( U_Name)
    Then
    F_Name
    Else
    SetNull()