surrogate keys usage in Oracle and Informatica?
Answer Posted / 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 |
Post New Answer View All Answers
What is substr in informatica?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is a surrogate key?
Explain the etl program with few examples.
What are mapplets?
what is the complex transformation you used in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the types of schemas we have in data warehouse and what are the difference between them?
Define filter transformation?
Explain the pipeline partition with real time example?
What are different types of transformations available in informatica?
Which are the different editions of informatica powercenter that are available?
Write the program through which the records can be updated?
What is the commit type if you have a transaction control transformation in the mapping?
How to use pmcmd utility command?