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
Repository user profiles
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Briefly define reusable transformation?
Write the advantages of partitioning a session?
Explain what are the different types of transformation available in informatica.
What are the differences between a connected lookup and unconnected lookup?
What are session parameters ? How do you set them?
What is a mapplet/worklet in informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Does an informatica transformation support only aggregate expressions?
Plz can any one say me how to get the informatica certification materials and dumps
write a query to retrieve the latest records from the table sorted by version(scd)
Different circumstance which drives informatica server to expel records?
What are the different ways to implement parallel processing in informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?