source target mapping

vikramkola · Post by **vikramkola** » Thu Oct 21, 2010 10:42 am

Hi ,

Source coloums in sequential file : A,B,C
Target coloums in table in oracle database:A,B,C,D,E

How to load this source file in to target table,
the coloums D,E in target table should be empty after loading.

chulett · Post by **chulett** » Thu Oct 21, 2010 10:53 am

Simply don't include D and E in your target stage. Either that or specifically map NULL to them.

naveen.p · Post by **naveen.p** » Thu Oct 21, 2010 12:23 pm

Hi,

Create Two Columns and use SetNull() Function.

HariK · Post by **HariK** » Fri Oct 22, 2010 3:29 am

If the fields have not null contraints you can load an empty string by using '' in the derivation for the fields.

chulett · Post by **chulett** » Fri Oct 22, 2010 6:30 am

Not for Oracle.

HariK · Post by **HariK** » Mon Oct 25, 2010 2:32 am

chulett wrote:Not for Oracle.

Thanks Craig for correcting.

vikramkola · Post by **vikramkola** » Mon Oct 25, 2010 7:12 am

Thank's to all of you.

DSXchange

source target mapping

source target mapping

Re: source target mapping