How to generate surrogate key without using surrogate key stage?
Answer Posted / murali
yes ur right but we have another way to generate s key by
using transformer .in transformer we have a surrogate key tab
click the skey tab in that we hav state file and db sequence
these r used for generate and hold the s key value
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the components of datastage?
Define Merge?
What are the features of datastage flow designer?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
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?
Define oconv () and iconv () functions in datastage?
What is oci?
What are the different layers in the information server architecture?
What are constraints and derivations?
What are the processing stages?
What are the areas of application?
How do you reject records in a transformer?
What is the flow of loading data into fact & dimensional tables?
On which Dimension Table you implemented SCD Type in your Project