what is the use of surogate key in datastage
Answers were Sorted based on User's Feedback
Answer / navin
DW is for to maintain historical & current data.
if use Natural key as primary key in DW we can't maintain
history.so we need a physical key in DW i.e is generated by
ETL developer .In DW we have develop a key called surrogate
key.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / pavani
we used the surrogate key for the sequence(for files in order)
ex we save one dummy value in some text file that dummy
value is surrogate key value when ever we are using the
surrogate stage we have to use that file for sequence order
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shiva
WE DONT USE PRODUCTION KEYs IN OUR DW, SO WE GENERATE OUR
OWN KEYS TO IMPLIMENT DW USING THIS SUROGATE KEY.
Is This Answer Correct ? | 2 Yes | 1 No |
What is "fatal error/rdbms code 3996" error?
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Which warehouse using in your datawarehouse
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the primary usages of datastage tool?
What is the difference between passive stage and active stage?
1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...
Define project in datastage?
how to define satge variables in transformer stage
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara