if(not isnull(Flag1) and not IsNull(Flag2),1,0 ) as MainFlag

[abhaysingh]

Hi,

Can anyone explain me the meaning of this expression?

thanks

[sujeetsingh]

That means Flag1 is not null and Flag2 is not null the 1 else 0.

[tresesco]

If both of Flag1 and Flag2 are not null, then 1, otherwise 0 (the value would be stored in a new field - MainFlag). In other words, if any of the flags is null, it will be 0, else 1.

Flag1	Flag2	result
null	null	0
null	Not null	0
Not null	null	0
Not null	Not null	1

[abhaysingh]

Common:

LOAD

     %Oracle_ID,

     2 as Flag2

FROM

D:\Gaurav\Secondary.qvd

(qvd);

Join

LOAD

     %Oracle_ID,

     1 as Flag1

FROM

D:\Gaurav\Primary.qvd

(qvd);

NoConcatenate

CommonFlag:

LOAD

  %Oracle_ID,

  if(not isnull(Flag1) and not IsNull(Flag2),1,0 ) as MainFlag

Resident Common;

MapCommon:

Mapping

LOAD

  %Oracle_ID,

  MainFlag

Resident CommonFlag;

DROP Table Common;

this is the code written by someone to full fill condition like from primary and secondary only comman %Oracle id Has to be fetch.. is it right?