I used OracleStage as an lookup.and i wrote an user-defined sql as:
select day_id,store_id, count(*) Record_count from dm_sale group by day_id,store_id.
I can able to ran the sql using Toad or sqlplus.
But while running the job it throws an error ora
day_id decimal(key field)
store_id decimal(key field)
Record_count decimal
Please help me on how to resolve trhis issue.
Satheesh