i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

Thomson Reuters,

in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?

Thomson Reuters,

can we import source table without using source qualifier? if yes then how? if no then why?

Thomson Reuters,

in my source table i want to delete first and last records and load in between records into target? how can it possible?

HCL, Thomson Reuters,

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

Thomson Reuters,

in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

Thomson Reuters,