what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
Answer Posted / soujanya
surrogate key is the system generated key to avoid primary
key conatraint.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a joiner transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What does role playing dimension mean?
How to partition the Session?
Explain the code page compatibility?
What is the fact table?
What are the components of the workflow manager?
How many ways a relational source definition can be updated and what are they?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to handle decimal places while importing a flatfile into informatica?
Explain what is informatica metadata and where is it stored?
Write the different tools in the workflow manager?
How you prepared reports for OLAP?
Explain sessions. Explain how batches are used to combine executions?
Performance tuning( what you did in performance tuning)