Answer / subhash

SRC--->SORT--->TFM--->TGT

In the Sort Stage, mention the Sort Keys and Set
CreateKeyChangeColumn to TRUE. for each 1st of Key column,
value of the KeyChange column is '1' and for the duplicate
columns, value is '0'.
In the TFM Constraints, give constraint as 'KeyChange=0' and
set '1' for 'Abort After Rows' then the job will abort for 1st
duplicate record.

Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.

2 Answers  

---

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?

10 Answers   Polaris,

---

what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,

---

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

0 Answers  

---

What are the processing stages?

0 Answers  

---

---

i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

---

how to design the change capture stage in(data stage parallel jobs) type 2

2 Answers   IBM,

---

what is use of SDR function?

0 Answers   CGI,

---

How many Key we can define in remove duplicate stage?

0 Answers   CTS,

---

What are the third party tools you used in your project?

1 Answers   IBM,

---

j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

1 Answers   Wipro,

---