If we have 1000 rows were loaded in to datawarehouse and
next day the source have 1010 rows so, how can we loaded
only updated rows into target.
Answer Posted / chinni
hi this is bhargav
u can use "control table logic" to do so
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Under what condition selecting sorted input in aggregator may fail the session?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is a joiner transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain dynamic target flat file name generation in informatica
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is a transaction control transformation?
without table how to come first record only in oracle?
Write the different tools in the workflow manager?
Explain in detail scd type 2 through mapping.
Explain target update override in informatica
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
State the differences between sql override and lookup override?
What is the difference between router and filter?