Interested to Buy Any Domain ? << Click Here >> for more details...
surrogate keys usage in Oracle and Informatica?
- 5 Answers
- 15700 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
Explain incremental aggregation in informatica
What is intricate mapping?
Sequence generator, when you move from develoment to production how will you reset
Can we override a native sql query within informatica?
Explain the different dimensions.
Explain joiner transformation in informatica
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is dimensional table?
Explain about cumulative Sum or moving sum?
How to do the error handling of if ur source is flatfiles?
How to update source definition?
How you can differentiate between connected lookup and unconnected lookup?
Mention a few design and development best practices for informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
