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


Please Help Members By Posting Answers For Below Questions

What is the process of killing a job in datastage?

581


what is ds administrator used for?

716


what is flow of project?

1551


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2020


What all are the different way to run a job?

635






What can we do with datastage director?

666


Describe the architecture of datastage?

562


What is difference between server jobs & parallel jobs?

617


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2422


Define Job control?

670


What are the important features of datastage?

611


Lookup constraints

835


What are the different options associated with dsjob command?

929


How to clean the datastage repository?

689


What is usage analysis in datastage?

805