Answer Posted / shiva
surrogate key is a artificial key or system generated
key.when ever a primary key violation occurs,by using
sequence generator t/m we generate surrogate keys
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can repository reports be accessed without sql or other transformations?
How are the sources and targets definitions imported in informatica designer?
What is incremental aggregation?
how to load rows into fact table in data warehouse
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
how tokens will generate?
What is meant by incremental aggregation?
In development project what is the process to follow for an etl developer from day1
where to store informatica rejected data? How to extract the informatica rejected data?
Explain sessions?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How do you load alternate records into different tables through mapping flow?