Answer Posted / vinod upputuri
Surrogate Key Stage is used to generate the Surrogate Key.
the main purpose of the Surrogate key is to maintain the
complete history in the dimension tables.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
To see hidden files in LINIX?
What is data partitioning?
What are the primary usages of datastage tool?
How and where you used hash file?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Define project in datastage?
What is merge stage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
how to implement scd2 in datastage 7.5 with lookup stage
how to add a new records into source?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the different kinds of views available in a datastage director?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is the difference between the local container and shared container?
I have a few records just I want to store data in to targets cycling way how?