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
Do you find any difficulty while working with flat files as source and target?
what is index?how it can work in informatica
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Explain the mapping variable usage example in informatica
Explain what are the different versions of informatica?
How does a sorter cache works?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
what is SDLC way of code development?
What do you mean by channel change?
How you prepared reports for OLAP?
expain about the tune parameters?
What is an active transformation?
How to join three sources using joiner?
Explain pmcmd command usage in informatica
generate date / time dimension in informatica