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

laxmi

• Nov 10th, 2014

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

sandeepsandeep

 Profile Answers by sandeepsandeep Questions by 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..)

Answer Question  Select Best Answer

Employee name start with A pass to one target,Employee name start with S pass to 2nd target,Employee name start with J pass to 3rd target,other pass to other target.

Sandy

• Aug 31st, 2014

To make current answers generic and mapping applies even if you get more names starting with different characters: Use Sorter, Expression & Transaction control transformations - Using sorter transfor...

amrie

• Jul 30th, 2014

In the expression Create a variable port v_employee= IIF( substr(EMPLOYEENAME,1,1)=A,FLAG1 IIF( SUBSTR(EMPLOYEENAME,1,1)=S,FLAG2, IIF( SUBSTR(EMPLOYEENAME,1,1)=J,FLAG3,FLAG4 ))) create a output po...

Answer Question  Select Best Answer