In Which scenario did u used Incremental loading?
Answers were Sorted based on User's Feedback
Whenever your record changes and any date column get
updated in source.This happens in mainly transactions where
amount or balance changes.This record is flagged based on
the the date colum which isnow changed and value become
greated then session run time when it was executed
previously.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ramu
for capturing the changed data in source we use the
incremental loading.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the necessity to use update strategy?(except for updates)
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
Describe two levels in which update strategy transformation sets?
Differnce between filter and router?
what is mystery dimension?
where actually the usage of push down optimization happens...
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
How to add source flat file header into target file?
What are the diffrences between joiner transformation and source qualifier transformation?
What is aggregator transformation in informatica?
How can you increase the performance in joiner transformation?
How do we call shell scripts from informatica?