Interested to Buy Any Domain ? << Click Here >> for more details...
How to generate surrogate key without using surrogate key stage?
- 6 Answers
- 30801 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / snehasis
By using system variable in transformer stage
like 1) create a stage var(SVK).
2) go to stage var. property type in the initial value tab as @partionnum - @numpartion+1
3) in the stage var. derivation type SVK+@numpartition
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Highlight the main features of datastage?
What is a quality stage in datastage tool?
What all the types of jobs you developed?
how to implement scd2 in datastage 7.5 with lookup stage
Why do you need stage variables?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
client know skid info?
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
What are the differences between datastage and informatica?
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?
What are sequencers?
How to manage date conversion in Datastage?
What is the difference between odbc and drs stage?
Describe routines in datastage? Enlist various types of routines.
