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 |
which r the connectors used in san?
eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000
With out using Funnel Stage, how to populate the data from different sources to single target
Why we use surrogate key?
what is set mapping in datastage??
what is use of SDR function?
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is the flow of loading data into fact & dimensional tables?
how to call sequential generator in datastage?
What is the difference between account and directory options ?
What is a folder? Difference types of stages?