Facing Problem in script with Record filtering

[#1]

Hi,

I have a requirement to fetch data from DB with multiple condition.I need the records with Flag='Y' and 'N' as well and for Flag=N, only Max(MD_DATE) is required.

1) I need to Fetch FIRST_NAME, LAST_NAME, CITY, ZIP_CODE, CUSTOMER_ID, MANUAL_FLAG, DB_ACTIVE_FLAG

from the DB WHERE (DB_ACTIVE_FLAG='Y' OR  DB_ACTIVE_FLAG='N') AND MANUAL_FLAG='Y' (Max(MD_DATE);

Could anyone help me on this?

Thanks in advance.

[Anonymous]

I would suggest a two step load:

1) load from database with the first condition

2) concatenate load with the second condition

In this scenario you cantest the two loads separately and you do not need to know exactly the syntax

of the combined condition!