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.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove du..

Answer / 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

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove du..

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

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove du..

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

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove du..

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

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove du..

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

Post New Answer

More Data Stage Interview Questions

which r the connectors used in san?

0 Answers  


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

2 Answers   HCL,


With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,


Why we use surrogate key?

0 Answers  


what is set mapping in datastage??

2 Answers   ADP,






what is use of SDR function?

0 Answers   CGI,


we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

0 Answers  


What is the flow of loading data into fact & dimensional tables?

0 Answers  


how to call sequential generator in datastage?

1 Answers   IBM,


What is the difference between account and directory options ?

0 Answers  


What is a folder? Difference types of stages?

0 Answers  


Categories