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
- 15131 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
Where do the datastage jobs get stored?
How to Remove Duplicate using SQL?
Can we use target hash file as a lookup ?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How to RD using transformer?
What is orabulk stage?
Why do we use link partitioner and link collector in datastage?
State the difference between an operational datastage and a data warehouse?
What are the components of datastage?
On which interface you will be working as a developer?
why do u need the IOS upgradation in a FC switch
which r the connectors used in san?
What are some prerequisites for datastage?
What is the flow of loading data into fact & dimensional tables?
Notification Activity
