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


Please Help Members By Posting Answers For Below Questions

What is a repository? And how to add it in an informatica client?

663


What do think which one is the better joiner or look up?

732


tell me the rules and responsblites in our project(my project is development)

1504


How to load the data from a flat file into the target where the source flat file name changes daily?

577


Explain lookup transformation in informatica

650






How to create or import flat file definition in to the warehouse designer?

618


What is workflow? What are the components of the workflow manager?

646


What is a stored procedure transformation?

611


What is a joiner transformation and why it is an active one?

580


Define Pmrep command?

642


Can we create a node as a gateway node and the same node can be assigned to a grid?

641


difference between informatica 8.1.1 and 8.6

3246


Explain why we use partitioning the session in informatica?

617


What are the issues you have faced in your project? How did you overcome those issues?

1916


Define sessions in informatica etl?

619