satyaneerumalla

• Sep 7th, 2006

 

IFF(DATE_DIFF(HIREDATE,DATE1,DATEFORMAT)>0) AND IFF(DATE_DIFF(DATE2,HIREDATE,DATEFORMAT)>0)

EX: DATEFORMAT 'DD',  'MM' etc.

swati

• Sep 18th, 2006

 

emp.hiredate >to_date('01-Jan-1981','DD-Mon-YYYY') andemp.hiredate < to_date('01-May-1981','DD-Mon-YYYY')

crishnathk

 Profile Answers by crishnathk 

• Dec 12th, 2006

 

thq for ur ans.....

i'm having dbt with filter transformation after completing my filter trans if i'm repeating the same trans by changing the condition it is not showing any result wat ever the filteration i have done earlier it is repeating.

cud u plz solve this............

jayapraveen

 Profile Answers by jayapraveen 

• Nov 8th, 2010

 

select * from emp where emp.hire_date>("DD-MM-YY)AND<(DD-MM-YY)

ms kumar

• Sep 8th, 2014

 

plz generate and execute the target table for every mapping by dropping the the table

naveenkumar

• Oct 14th, 2014

 

execute the target table for mapping to table

Nagas

• Nov 24th, 2014

 

Use the SQL condition "Between and AND" as a filter condition in the mapping