1.how to generate even numbers in surrogate or tranformar
stage ?
2. how many ways to remove duplicate values?
Answers were Sorted based on User's Feedback
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 |
Answer / 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 |
Answer / kumar
By using distinct we can eliminate duplicates,
by using variable comparison we can eliminate duplicates.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / pavan
To remove duplicates we could use Remove Duplicates Stage.
If the requirement states not to use a remove duplicates
stage, u culd use Sort stage, by setting one of its
property Allow Duplicates to false.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / kiran
IN surrogate key generator stage set the block size to 2
with initial value as 2, it will increment the surrogates
by 2 and will get you even numbers. I don't think in any
real world scenario you would do this as it violates
surrogate key concept. I wish the interviewer knew this
before he/she asked you.
Is This Answer Correct ? | 1 Yes | 4 No |
Whats difference betweeen operational data stage (ods) and data warehouse?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
In merge stage can we update the values?
how to do pergformence tuning in datastage?
what is meta data? Explain? Where it is used?
What is the difference between informatica and datastage?
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?
i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?
How did you reconcile source with target?
what is data mapping
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
what is meant by port ? what is the use of port ? what are the different type of ports and its usage