What is a surrogate key?Why we use it in a mapping?Pl give
an example.
Answer Posted / sanjay
Saradhi has given the perfect example of Surrogate key..
Thnx Saradhi
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Name the different lookup cache(s)?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Why filter transformation is an active one?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is a repository? And how to add it in an informatica client?
What is a transaction control transformation?
What is meant by LDAP users?
State the limitations where we cannot use joiner in the mapping pipeline?
Explain scd type 3 through mapping.
-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?
What is a pre-defined event and user-defined event?
Define update strategy?
Design a mapping to load a target table with the following values from the above source?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?