what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
Answer Posted / kalpana
Some times the primary constraint may violate at that time
we go for surrogate key.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is an unconnected transformation?
How many transformations can be used in mapplets.
How to update source definition?
Explain pmcmd command usage in informatica
Slowly changing dimensions, types and where will you use them
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How do you migrate data from one environment to another?
What is depict expression change?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How does a rank transform differ from aggregator transform functions max and min?
What is the benefit of partitioning a session?
How you prepared reports for OLAP?
What is informatica etl tool?
What are some examples of informatica etl programs?
What do you mean by channel change?