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

What are some different alternative commands associated with "dsjob"?

1212

---

Notification Activity

1457

---

Where do the datastage jobs get stored?

1268

---

Define Merge?

1374

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1112

---

Define Data Stage?

1140

---

What are the types of views in datastage director?

1824

---

what is the custome stage in datastage? how can we impliment that one? plz tell me

2409

---

Describe the main features of datastage?

1123

---

How do you run datastage job from the command line?

1129

---

What is difference between server jobs & parallel jobs?

1087

---

describe the Steps to confiure a Qlogic switch

2437

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

3018

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2776

---

Differentiate between data file and descriptor file?

1105

---