1.how to generate even numbers in surrogate or tranformar
stage ?
2. how many ways to remove duplicate values?
Answer Posted / pavan
To generate even numbers using transformer, we can make use
of stage variables. declare a stage variable say SV1 and
initialise it to 0. In the derivation of that stage
variable increment it by 2 which looks like SV1+2. By doing
this we can generate even numbers.
mail me @ akellapavankumar@gmail.com for more info.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What all the types of jobs you developed?
What could be a data source system?
What is the difference between datastage and datastage tx?
What is merge stage?
What are system variables and sequencers in datastage
What is a ds designer?
Highlight the main features of datastage?
What are routines in datastage? Enlist various types of routines.
Define Job control?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Define data aggregation?
What is the sortmerge collector?
Can we use target hash file as a lookup ?
What is difference between symmetric multiprocessing and massive parallel processing?
Explain the importance of surrogate key in data warehousing?