Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / chandrasekar
Whenever an OLTP records update or insert in the source
,then the records are loaded in to target as a new record.
Using SCD type 2 we can acheive the incremental load.
If it wrong means chandranmca2007@gmail.com
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is dynamic cache?
Mention few power centre client applications with their basic purpose?
What does reusable transformation mean?
what is the -ve test case in your project.
what are 3 tech challenges/ common issues you face?
What is meant by lookup transformation?
how many types of dimensions are available in informatica?
What is the function of union transformation?
Difference between Target-based loading and constraint-based loading?
What does role playing dimension mean?
How can we use batches?
What are the features of complex mapping?
difference between repository database and repository service?
Difference between Data and Index Caches?
