Answer / kiran

Hai..,

In sort stage we have one property...its create key change
column.

In Transformer stage ,we have to write if then else
condition.....

Answer / subhash

In sort stage, we have 'create key change
column' property.
i.e, The KeyChange column is set to 1 for the first record
in each group where the value of the sort key changes.
Subsequent records in the group have the KeyChange column
set to 0.

In Transformer stage ,we can put constraint as IF KeyChange
= 1 then map to the TGT.

Answer / harikiran

in transformer stage output properties tab there is a
sorting option if u mention sort option there are two more
operations are there like unique and stable sort. if u
click on uniqu it will restrict the duplicates

Answer / kalyanreddy

Yes, Kirans is right

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,

---

What are the various kinds of the hash file?

0 Answers  

---

What is a range lookup?

2 Answers   IBM,

---

Define meta stage?

0 Answers  

---

Can you explain link buffering?

0 Answers  

---

What is the difference between orabulk and bcp stages?

0 Answers  

---

Pls tell me what is troubleshooting in datastage view?

1 Answers  

---

Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,

---

How can we run same job in 1 day 2 times

7 Answers   IBM,

---

how many types of sorting the data in data stage?

1 Answers   BoA, IBM,

---

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

---

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,

---