surrogate keys usage in Oracle and Informatica?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / mahendra reddy ongole
surrogate key is system generated sequence numbers which
are used for maintaining the history in SCD-TYPE-2
applications
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / tanmoy
A surrogate key is the substitution of natural primary key
Is This Answer Correct ? | 3 Yes | 3 No |
What is the sql query overwrite in source qualifier in informatica
How can yoU improve session performance in aggregator transformation?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
What is dimensional table? Explain the different dimensions.
what is update strategy transformation ?
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
What is repository manager?
I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
Why you use repository connectivity?
What is the difference between stop and abort in informatica