Answer Posted / latha
actually it appears in picture when a critical
column(example location) occurs in a table.In order to avoid
the critical column we are using surrogate key.surrogate key
is also a primary key.
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Can informatica load heterogeneous targets from heterogeneous sources?
What is the difference between informatica 7.0 and 8.0?
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.
In warehouses how many schemas are there?
what is song in infrmatica...?
What can we do to improve the performance of informatica aggregator transformation?
How do you migrate data from one environment to another?
What is workflow manager?
design of staging area?
explain about unit testing? in real time?
Explain sessions. Explain how batches are used to combine executions?
Define the various join types of joiner transformation?
Why sorter is an active transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
what is $$$$?