Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any possibility to generate alphanumeric surrogate
key?
- 3 Answers
- 12016 Views
- ABC, IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between the local container and shared container?
How many types of stage?
Demonstrate experience in maintaining quality process standards?
How do y read Sequential file from job control?
Why do we use exception activity in Datastage?
Difference between server jobs & parallel jobs?
What are stage variables, derivations and constants?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Name the command line functions to import and export the DS jobs?
How to read multiple files using a single datastage job if files have the same metadata?
client know skid info?
Difference between data warehousing and olap?
How many areas for files does datastage have?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
