surrogate keys usage in Oracle and Informatica?
Answer Posted / avinash kumar
If u have mulitiple records then for mentain this records we
need to generate surrogate key in informatica
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Repository user profiles
what is Active lock explain
What are the types of caches in lookup? Explain them.
Global and Local shortcuts. Advantages.
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
I have a flat file, want to reverse the contents of the flat file
Which files are created during the session rums by informatics server?
What is informatica? Why do we need it?
What all are steps in up gradation of Informatica server?
What do you mean by blocking transformation?
What are session parameters ? How do you set them?
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.
Which transformation is needed while using the Cobol sources as source definitions?
Explain the etl program with few examples.