Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nivas
Surrogate key is a system generated sequence numbers. It is
also called artificial key.Sarrogate key using as a primary
key without using sarrogate key we can't do SCD type2
implemenation.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How to do unit testing in informatica? How to load data in informatica ?
Explain load alternative records / rows into multiple targets - informatica
What is lookup transformation?
What are the performance considerations when working with aggregator transformation?
How do you load unique records into one target table and duplicate records into a different target table?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How can you differentiate between powercenter and power map?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
According to his methodology what all you need before you build a datawarehouse
How to generate sequence numbers?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the use of code page?
