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
Can we use target hash file as a lookup ?
In Datastage, how you can fix the truncated data error?
What are the types of hashed files in data stage
Explain connectivity between datastage with datasources?
What are some prerequisites for datastage?
What is the use of datastage designer?
Why do we use link partitioner and link collector in datastage?
What is "fatal error/rdbms code 3996" error?
what is flow of project?
Define Routines and their types?
Distinguish between informatica & datastage. Which one would you choose and why?
Differentiate between validated and Compiled in the Datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Define data aggregation?
Explain Quality stage?