Answer Posted / navin
DW is for to maintain historical & current data.
if use Natural key as primary key in DW we can't maintain
history.so we need a physical key in DW i.e is generated by
ETL developer .In DW we have develop a key called surrogate
key.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Define Job control?
Can you explain kafka connector?
Explain Quality stage?
whom do you report?
What are the various kinds of the hash file?
what is flow of project?
What is staging variable?
What is a merge in datastage?
What is the difference between the local container and shared container?
Where the datastage stored his repository?
AGGREGATOR default datatype
Explain usage analysis in datastage?
What are transforms and what is the differenece between routines and transforms?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
I have a few records just I want to store data in to targets cycling way how?