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 / babu
By selecting 'UPDATE else insert' in the 'Treat source rows
as :'from
session properties we can get updated rows and new rows..
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain dynamic target flat file name generation in informatica
Make a note of the quantity vaults made in informatica?
In informatics server which files are created during the session rums?
Why union transformation is an active transformation?
What are multi-group transformations?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
what is SDLC way of code development?
How to create a non-reusable instance of reusable transformations?
What is the difference between router and filter?
What are the different types of repositories created using informatica?
pmscmd startworkflow -sv
what is the size of u r source(like file or table)?
What is informatica powercenter repository?
Differentiate between reusable transformation and mapplet.
how to create user defined function (udf) in informatica