1 - 2 of 2 Comments Last updated May 6, 2014
Ramana Akunuri

Washington, DC

#1 Sep 29, 2013
Hi Some body answer my question please

I am comparing a flat file and Oracle. In one of the column in flat file have a blank and Oracle table have Null. It is failing I would like to set up an expression the expression is I thought is not working can you please help me

IIF(variable1 IsNull,blank,variable1)

It is giving me operation missing error

I some other case in flat file the state column is blank and Oracle table have ** in in I fixed that problem by writing expression.

In expression one B i entered following and it is passed
IIF(variable1,'**',blank,varia ble)
David Otte

Aurora, CO

#2 May 6, 2014
Try this:
IIF(IsNull(variable1),'',varia ble1)

Tell me when this thread is updated: (Registration is not required)

Add to my Tracker Send me an email

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Informatica Discussions

Title Updated Last By Comments
Is there a way to see a detail of the last run ... Aug 26 Jack 1
informatica Aug 13 swetha 1
Informatica 9 certification dumps (Dec '12) Jul '14 Rahul 22
informatica May '14 simson 1
Informatica services start and stop May '14 Tanguturi 1
Error while installing informatica Apr '14 krishna 1
Informatica 9.5.1 with OBIA Apr '14 Anonymous 1
Enter and win $5000

Informatica People Search

Addresses and phone numbers for FREE