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

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2209

---

what is the use of surogate key in datastage

2296

---

Differentiate between datastage and informatica?

1170

---

which r the connectors used in san?

2175

---

What are the different common services in datastage?

1269

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2491

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1397

---

Define meta stage?

1186

---

Differentiate between Join, Merge and Lookup stage?

1075

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2277

---

How to read the length of word in unix?

1367

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3781

---

what is flow of project?

1980

---

Which commands are used to import and export the datastage jobs?

1404

---

What are the types of views in datastage director?

1757

---