what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
- 6 Answers
- 12190 Views
- I also Faced
- E-Mail Answers
Answer Posted / soujanya
surrogate key is the system generated key to avoid primary
key conatraint.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What differs when we choose the sorted input for aggregator transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain what are the different types of transformation available in informatica.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Clarify the aggregator change?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What do you mean by enterprise data warehousing?
In which transformation you cannot drag ports into it?
Explain the features of connected and unconnected lookup.
Explain how to import oracle sequence into informatica?
How to partition the Session?
Performance tuning( what you did in performance tuning)
What could be the possible resons of locks by user?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
