Is there any possibility to generate alphanumeric surrogate
key?
Answers were Sorted based on User's Feedback
You can generate AlphaNumeric surrogate key but not in surrogate stage, You need to put your logic in transformer
thanks
www.datagex.net
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / dhana
Only a primary key can be alphanumeric and the surrogate key is etl generated key and it cannot be alphanumeric and it is only numeric.
| Is This Answer Correct ? | 0 Yes | 1 No |
how to implement scd2 in datastage 7.5 with lookup stage
What is a folder? Difference types of stages?
Thanks to all people who are posting their comments...
What all are the different way to run a job?
Why we need datasets ratherthan sequential files?
What is the method of removing duplicates, without the remove duplicate stage?
How a routine is called in datastage job?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?
6 Answers CTS, HCL, IBM, Wipro,
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?