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


Please Help Members By Posting Answers For Below Questions

How to implement complex jobs in data stage?

888


What are the types of views in datastage director?

1556


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3237


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.

3790


What are stage variables, derivations and constants?

944


Differentiate between datastage and informatica?

971


How do you generate sequence number in datastage?

866


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2126


Define oconv () and iconv () functions in datastage?

1140


On which Dimension Table you implemented SCD Type in your Project

1803


How to convert RGB Value to Hexadecimal values in datastage?

3716


Define APT_CONFIG in Datastage?

875


What is the roundrobin collector?

875


what is ds administrator used for?

947


Can you explain engine tier in information server?

894