binoy_pa

 Profile Answers by binoy_pa Questions by binoy_pa

• Apr 24th, 2006

 

update  strategy  function   will  not   work  in    the  mapping,its only  do  the  insert.

windows

 Profile Answers by windows Questions by windows

• Jun 2nd, 2006

 

You can set the following update strategy options: Insert. Select this option to insert a row into a target table. Delete. Select this option to delete a row from a table. Update. You have three different options in this situation: Update as update:Update each row flagged for update if it exists in the target table. Update as insert: Insert each row flagged for update. Update else insert : Update the row if it exists. Otherwise, insert it.

Prasad

• Jul 14th, 2006

 

hi,

if u r using a update strategy in any of ur mapping, then in session properties u have to set treat source rows as Data Driven. if u select insert or udate or delete, then the info server will not consider UPD for performing any DB operations.

ELSE

u can use the UPD session level options. instead of using a UPD in mapping just select the update in treat source rows and update else insert option. this will do the same job as UPD. but be sure to have a PK in the target table.

2) for oracle : SQL loader

for teradata:tpump,mload.

3) if u pass only 5 rows to rank, it will rank only the 5 records based on the rank port.