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
Define mapplet?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Explain the shared cache and re-cache?
What is source qualifier transformation in informatica?
What are the main issues while working with flat files as source and as targets ?
What is the difference between source qualifier transformations source filter to filter transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the different components of powercenter?
What if the source is a flat-file?
how to load rows into fact table in data warehouse
what is Active lock explain
Explain joiner transformation in informatica
Differentiate between a database and data warehouse?
Which is the t/r that builts only single cache memory?
When do you use sql override in a lookup transformation?