surrogate keys usage in Oracle and Informatica?
Answer Posted / ranjan
surrogate key is one type of key which is used to maintain
history .
it is used in slowly changing dimension (scd)
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the use of target designer?
What is the difference between STOP and ABORT options in Workflow Monitor?
What do mean by local and global repository?
Why update strategy and union transformations are active?
How do you promote a non-reusable transformation to reusable transformation?
How to elaborate tracing level?
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,
Name at least 5 different types of transformations used in mapping design and state the use of each.?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is dynamic cache?
How identifying bottlenecks in various components of informatica and resolving them?
What is a code page?
Informatica Checkpoints
what is $$$$?