how to get the only updated records in the target

Answer Posted / jvdwhinfo

Using incremental aggregation.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What could be the possible resons of locks by user?

659


What are pre and post-session shell commands?

735


How do you load unique records into one target table and duplicate records into a different target table?

703


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1621


Quickly characterize reusable change?

687






How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

688


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1866


expain about the tune parameters?

1877


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1027


Where do we use mapping variables in informatica?

611


Mention some types of transformation?

602


What are the differences between source qualifier and joiner transformation?

594


update strategy transformation in informatica

638


How do you promote a non-reusable transformation to reusable transformation?

658


What are Dimensional table?

608