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 a repository? And how to add it in an informatica client?
What do think which one is the better joiner or look up?
tell me the rules and responsblites in our project(my project is development)
How to load the data from a flat file into the target where the source flat file name changes daily?
Explain lookup transformation in informatica
How to create or import flat file definition in to the warehouse designer?
What is workflow? What are the components of the workflow manager?
What is a stored procedure transformation?
What is a joiner transformation and why it is an active one?
Define Pmrep command?
Can we create a node as a gateway node and the same node can be assigned to a grid?
difference between informatica 8.1.1 and 8.6
Explain why we use partitioning the session in informatica?
What are the issues you have faced in your project? How did you overcome those issues?
Define sessions in informatica etl?