Answer Posted / sunil kumar singh
Surrogate Key is artificial that is created for
datawarehousing for generating the unique number for each
record. Surrogate key works on the behalf of primary key.
And main purpose of surrogate key is to maintain the
historical record.
| Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
What is decode in informatica?
Explain the shared cache and re-cache?
What are the different types of olap? Give an example?
How to delete duplicate row using informatica?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are mapplets?
How do you manage the Parameter files while migrating your data from one environment to another environment?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How you prepared reports for OLAP?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is the function of union transformation?
What is meant by LDAP users?
What are mapplets? How is it different from a Reusable Transformation?
What is an unconnected transformation?