Answer Posted / ankit gosain

Hi,

You can block any specified record(s) from the source seq.
file with the help of a Transformer Stage.

Source Seq. File ----> Transformer ---->Target Seq. File

Now, in Transformer stage create a Stage Variable (say
row_num) & initialize it with ZERO.
In it's derivation, just increment it by ONE (i.e.
row_num+1)

Now, Insert a new column in the output & it's derivation,
assign the variable (row_num).

Now, in the contraint tab wirte row_num<>10 OR row_num<>11

If you have some other doubts or queries, you can mail me
on ankitgosain@gmail.com

Cheers,
Ankit :)

how many rows sorted in sort stage by default in server jobs

3984

---

On which interface you will be working as a developer?

1030

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2432

---

AGGREGATOR default datatype

1438

---

Can you define merge?

1102

---

Lookup constraints

1236

---

how to sort two columns in single job in datastage.

2885

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1398

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2473

---

What are the partitioning techniques available in link partitioner?

2261

---

How do you generate sequence number in datastage?

1072

---

What can we do with datastage director?

1223

---

What is a merge?

1139

---

What is the difference between validated and compiled in the datastage?

1266

---

What is apt_config in datastage?

1125

---