How to remove the null values in flat file ?

Import flat file from the source (with nulls) it should display without null values in the target

Questions by madhulatha   answers by madhulatha

Showing Answers 1 - 5 of 5 Answers


  • Jul 13th, 2014

By default Informatica display * as Null.

You should change the file properties at session level to select a value to display instead of showing *(null).

It can be replaced with space so that if we have spaces populated instead of NULL.

  Was this answer useful?  Yes


  • Jul 14th, 2014

I guess you can handle this situation inside Expression T/R and pass non NULL rows.

  Was this answer useful?  Yes


  • Jul 16th, 2014

Can we use condition like "not isnull(column name)" in filter transformation and make downstream connection

  Was this answer useful?  Yes

after importing the flatfile, after the source qualifier use an expresssion transformation. In expression transformation use the condition IIF(column=NULL,0,Column)

(you can use either 0 or any other value u like..)

  Was this answer useful?  Yes


  • Nov 10th, 2014

We can use validate record component with is_null() function.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions