Power center -DVO question

Power center -DVO question

Posted in the Informatica Forum

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

Englewood, CO

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

Tell me when this thread is updated:

Subscribe Now Add to my Tracker

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
How to Handle Horizontal tab in Flat file in in... (Sep '15) Jul 15 ann_p 2
active and passive t/f Jul 15 ann_p 2
Loading a specific Erwin model version into Met... Apr '16 SCHJA26 1
not recognizing the source file (Jun '08) Mar '16 Jayashree 2
calling informatica powercentre workflow as a s... Mar '16 anil 1
Update Records Feb '16 beginer_informatica 1
First and last rec from flat file to table Feb '16 Nan 1
More from around the web