Interested to Buy Any Domain ? << Click Here >> for more details...
surrogate keys usage in Oracle and Informatica?
- 5 Answers
- 15757 Views
- ITC Infotech, Oracle, I also Faced
- E-Mail Answers
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 informatica? Why do we need it?
How to Create a folder using pmrep command?
In informatica workflow manager, how many repositories can be created?
Plz can any one say me how to get the informatica certification materials and dumps
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
can we override a native sql query within informatica? How do we do it?
Define sessions in informatica etl?
Which transformation should we use to normalise the COBOL and relational sources?
What is the Rank index port in Rank transformation?
What is complex mapping?
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,
What are batches?
What are the features of complex mapping?
What is a predefined event?
