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
- 15346 Views
- Gallega, TCS, I also Faced
- E-Mail Answers
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 |
how many stages are there in Datastage... Please clarify mee??
Demonstrate experience in maintaining quality process standards?
What is difference between 8.1 , 8.5 and 9.1 ?
What are the different types of lookups in datastage?
What are transforms and what is the differenece between routines and transforms?
What is the use of hoursfromtime() function in transformer stage in datastage?
Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,
What is the use of Row generator stage?
How we can convert rows to columns in datastage?
What is the difference between Link collector and Funnel Stages?
How can we run same job in 1 day 2 times
how many types of sorting the data in data stage?
Teradata 
