Interested to Buy Any Domain ? << Click Here >> for more details...
1.how to generate even numbers in surrogate or tranformar
stage ?
2. how many ways to remove duplicate values?
- 5 Answers
- 14861 Views
- Gallega, TCS, I also Faced
- E-Mail Answers
Answer Posted / subhash
1) By using Stage variables in transformer, we can generate even numbers,
Declare a stage variable - SV1 and initialize to '0'.
In the derivation of that stage variable increment by 2.
i.e. SV1=SV1+2.
By using Surrogate key in transformer, use the below logic in derivation part.
Surrogate_Key -----> If mod(Surrogate_Key,2)= 0 then Surrogate_key Else Surrogate_Key + 10000001
2)Removing Duplicates
a. By using Remove Duplicates Stage.
b. By using SORT Stage,Sort on KEY Column and set 'Allow Duplicates' to 'FALSE'
c. By using Link Partitioning, use 'HASH partition' on KEY Columns and Select Perform Sort and UNIQUE options.
d. By using Transformer Stage Variables,
SV2----->If SV1=KEY_Column then 0 Elso 1
SV1----->KEY_Column
In the Constraint Part give as,
SV2=1
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Which commands are used to import and export the datastage jobs?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What are the different types of lookups in datastage?
What is ibm datastage?
What are the primary usages of datastage tool?
How many types of hash files are there?
What is ds designer?
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
How many Key we can define in remove duplicate stage?
What is the difference between datastage and informatica?
What are the enhancements made in datastage 7.5 compare with 7.0?
What are the benefits of datastage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
