Answer Posted / susheel sharma
in our project we used store procedure to implement CDC
(change data capture) for incremental data load.
generaly store procedure used when you have to implement
your complex business logic.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is target designer and target load order?
What is the different lookup cache(s)?
Write the prerequisite tasks to achieve the session partition?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
what is the size of your data warehousing?
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?
Enlist few areas or real-time situations where informatica is required.
define galaxy repository in informatica
What is olap (on-line analytical processing?
What is an expression transformation in informatica?
Write the advantages of partitioning a session?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Explain pushdown optimization $pushdownconfig parameter - informatica
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?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records