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 is job control?
options available in sequence job to run,validate?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Terminate Activity
What is the difference between server job and parallel jobs?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Explain the situation where you have applied SCD in your project?
What is the method of removing duplicates, without the remove duplicate stage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How do you register plug-ins?
Difference between in process and inter process?
What is the difference between operational data stage (ods) and data warehouse?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
CHANGE CAPTURE
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this