what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?

Answer Posted / dr.jornalist

Surrogate Key:- Surrogate key is a system generated primary
key used in informatica for maintaining history of values.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the different lookup cache(s)?

621


How can you define user defied event?

635


Explain the different lookup methods used in informatica?

599


Which development components of informatica have the highest usage?

605


What is workflow? What are the components of workflow manager?

719






Whats the difference between informatica powercenter server, repositoryserver and repository?

690


How to convert multiple rows to single row (multiple columns) in informatica

906


Tell me about Propagate functions in informatica

536


tell me the rules and responsblites in our project(my project is development)

1512


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.

1266


Design time, run time. If you don't create parameter what will happen

1435


Is there any way to read the ms excel datas directly into informatica?

558


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4998


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1643


What do you mean by filter transformation?

565