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

Aurora, 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
Beginner Informatica Developer (Feb '13) Nov 23 Kahir 3
News Informatica says new big data platform nails se... Nov 23 Kahir 1
Informatica 9 certification dumps (Dec '12) Nov 23 Kahir 30
How to Handle Horizontal tab in Flat file in in... Sep '15 Ashwini 1
How to load data from oracle table to an excel... Sep '15 aruntvs 1
Duplicate record removal in informatica using s... Sep '15 sunil pandey 2
Complex Scenario Sep '15 senthil kumar Man... 1
More from around the web