what i said s only for relational targets. for flat files there r some target load options like Loader, but i dunno how to use it. if we cant use in that case i think we shuld use update strategy...
Type: Posts; User: sat.inn; Keyword(s):
what i said s only for relational targets. for flat files there r some target load options like Loader, but i dunno how to use it. if we cant use in that case i think we shuld use update strategy...
u can see the codes while giving generate and execute command in the warehouse designer
go to the workflow manager-connectoins-relational, configure sourec and target connectoins according to the database u r using, and have to change the sessoin properties and sessoin mappings before...
just do a straight load...that one row will be inserted into the target table.
Click the update as update checkbox in the target load option and then run the session once again.do reply
hi! edit sessoin--->give insert and update as update in the target load option.
hope ur problem wil be solved
How to remove duplicate rows using router and filter?