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

digvijay

  • 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

Abhinav

  • Jul 14th, 2014
 

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

  Was this answer useful?  Yes

poovendhiran

  • Jul 16th, 2014
 

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

  Was this answer useful?  Yes

sandeepsandeep

  • Aug 11th, 2014
 

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

laxmi

  • 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