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
- 15115 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
Why do we use exception activity in Datastage?
Why do we use link partitioner and link collector in datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Can you implement SCD2 using join, transformer and funnel stage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Difference between sequential file and data set?
Notification Activity
What is the difference between datastage and informatica?
what is the use of skid in reporting?
How a routine is called in datastage job?
How many types of views are there in a datastage director?
How to clean the datastage repository?
what are the devoleper roles in real time? plz tell i am new to datastage....
