what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
Answer Posted / raghureddy
It has system generated artificial primary key values .
which allows to maintian historical data in dwh
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the different dimensions.
what is the hint? how to use it to reduce the query processing in program?
Separate from a database, an information bazaar, and an information stockroom?
Explain dynamic target flat file name generation in informatica
What is a filter transformation?
What is sequence generator transformation in informatica?
EXL informatica Questions
Define mapping and session?
In warehouses how many schemas are there?
Design a mapping to load a target table with the following values from the above source?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is deployment group?
How do you load alternate records into different tables through mapping flow?
What is fact table? Explain the different kinds of facts.
In how many ways we can create ports?