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 / mahipal reddy
By selecting 'UPDATE' in the 'Treat source data as:'from
session properties we can get only updated rows..
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
What is the difference between Active and Passive transformation?
Explain informatica architecture - version 8 / 9
wat are deployement groups in informatica, how it will be used for developers
What is the function of union transformation?
What are the types of presistent cache in look up tr.
What are the new features of Power Center 5.0?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to create or import flat file definition in to the warehouse designer?
What do you mean by blocking transformation?
What is the difference between router and filter?
Describe an informatica powercenter?
How to load the data from people soft hrm to people soft erm using informatica?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How to generate sequence numbers without using the sequence generator transformation?
How to use procedural logic inside infromatica?