when i impement incremental load one error is occurred and how to get the solution please help me...

[#1]

when i impement incremental load one error is occurred and how to get the solution please help me...

  Please find the attached details.

Thanks & regards

raja

[Anonymous]

What is in your variable vHIREDATE ?

[#3]

Hi Raja,

What is there in Your variable( vHIREDATE) -----?

Ramya.

[#4]

!

[#5]

hi ramya ,

   please find the attached document.

Thanks & regards

raja

[Anonymous]

Try something like :

HireDate_Emp:

NoConcatenate

LOAD HIREDATE

Resident Employee

Order By HIREDATE asc;

LET vHIREDATE = Peek('HIREDATE',0,'HireDate_Emp');

trace $(vHIREDATE) ;

[#7]

hi bill,

   i tried this still i'm getting the same error.

thanks & regards

raja

[#8]

Hi Raja,

U can try this variable:

LET vHIREDATE = Peek('HIREDATE',0,'HireDate_Emp');

trace $(vHIREDATE)

Ramya.

[#9]

Hi,

I think it is a problem with Date field u r using the field as hiredate,

check with the database time format it is matching with it r not.

before that, check with this

where hiredate >= Today();

I hope it will help u to complete u r task.

Thank you,

Balaji.k