surrogate keys usage in Oracle and Informatica?
Answer Posted / palani
Its mainly used to maitain the uniqueness in the target
system that contains records from various source systems
ie. different source system may contain different keys as a
primary key.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the features of connected and unconnected lookup.
what is the Default Source Option For Update Strategy Transformation?
What is the function of look up transformation?
What is the format of informatica objects in a repository?
Define the various join types of joiner transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How do you promote a non-reusable transformation to reusable transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is mapping debugger?
tell me 5 session failure in real time how can you solve that in your project?
How do we call shell scripts from informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is rank index in rank transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
On which transformations you created partitions in your project?