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
What are the data movement modes in informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain about Informatica server process that how it works relates to mapping variables?
What is mapplet in informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How can we use mapping variables in informatica?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How to generate sequence numbers without using the sequence generator transformation?
What do you mean incremental aggregation?
What are the new features of informatica 9.x at the developer level?
How can we store previous session logs?
Differentiate between source qualifier and filter transformation?