How to generate surrogate key without using surrogate key stage?
Answer Posted / venkatesh.m
by using the transformer we can do it.To generate seqnum
there is a formula by using the system variables
ie
[@partation num + (@inrow num -1) * @num partation
Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
How to implement complex jobs in data stage?
What are the types of views in datastage director?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are stage variables, derivations and constants?
Differentiate between datastage and informatica?
How do you generate sequence number in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Define oconv () and iconv () functions in datastage?
On which Dimension Table you implemented SCD Type in your Project
How to convert RGB Value to Hexadecimal values in datastage?
Define APT_CONFIG in Datastage?
What is the roundrobin collector?
what is ds administrator used for?
Can you explain engine tier in information server?