Interested to Buy Any Domain ? << Click Here >> for more details...
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING
SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT
EVEN IF THE JOB IS COMPILED REPEATEDELY?
- 4 Answers
- 18072 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / kiran
If you want the SCD stage to generate new surrogate keys by
using a key source that you created with a Surrogate Key
Generator stage, you must use the NextSurrogateKey function
to derive the Surrogate Key column.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are stage variables, derivations and constants?
What is the sortmerge collector?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
How do you schedule or monitoring the job?
What is the difference between an operational datastage and a data warehouse?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is use Array size in datastage
On which interface you will be working as a developer?
explain about citrix scheduling tool in datastage
Why do we use link partitioner and link collector in datastage?
How and where you used hash file?
Why fact table is in normal form?
Difference between in process and inter process?
