How do u check the source for the latest records that are to be loaded into the target.i.e i have loaded some records yesterday, today again the file has been populated with some more records today, so how do i find the records populated today.thanks in advance

kiran_stealth@yahoo.com
Profile Answers by kiran_stealth@yahoo.com Questions by kiran_stealth@yahoo.com
Apr 19th, 2006
5
1599

Showing Answers 1 - 5 of 5 Answers

sanjeev

Apr 20th, 2006

Hi,
Keep a timestamp in the target table and from that you can get the daily loaded record status

CHOLLETI KIRAN KUMAR

May 4th, 2006

u can check session properties from workflow monitar.. u can find new updated records
CHOLLETI KIRAN KUMAR

krishna

May 12th, 2006

a) Create a lookup to target table from Source Qualifier based on primary Key.
b) Use and expression to evaluate primary key from target look-up. ( If a new source record look-up primary key port for target table should return null). Trap this with decode and proceed.
Good Luck,
K.

Shanmugam

Jul 5th, 2006

You can use the incremental loading concept. Store the last_run_date as SYSDATE each time you run the session in an variable and use it next time you load your target.

Prasad

Jul 14th, 2006

hi,
use a lookup for this. consider ur targer table as the lookup table.check for the existence. and use the session level properties. select treat source rows as update and in mapping tab->target view, select insert and update as insert. this ensures that only the new records gets inserted and the old records are unchanged.