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 / aswinigallery@gmail.com
Yes, we can use scd type 1 (only update flow).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Different sorts of metadata that stores in the storage facility?
What are the types of caches in lookup? Explain them.
What is incremental aggregation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Enlist the various types of transformations.
can anyone suggest best free Talend data integration training online
What is an active transformation?
What is the meaning of up gradation of repository?
What is joiner change?
What are the static cache and dynamic cache in informatica?
What are the informatica performance improvement tips
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Implementation methodology