Answer Posted / subhash

1. SRC--->FILTER---->TGT1,TGT2,TGT3
In source query,
SELECT COL1,
RANK() OVER(PARTITION BY COL1 ORDER BY COL1) SNO
FROM TABLE
in filter,
col1='d1'------>TGT1
col1='d2'------>TGT2
col1='d3'------>TGT3

2. SRC---->TFM---->TGT1,TGT2,TGT3
in TFM, do the HASH partitioning on col1 and use the stage
varibles as below:
if col1 =prevCol then SV1=S1+1
else SV1=1
prevCol---->col1

In the link constraints:
TGT1 link, COL1='d1'
map SV1, COL1 to the tgt.

TGT2 link, COL1='d2'
map SV1, COL1 to the tgt.

TGT3 link, COL1='d3'
map SV1, COL1 to the tgt.

What are the different type of jobs in datastage?

1082

---

how can we create rank using datastage?what is the meaning of rank?

8856

---

Describe routines in datastage? Enlist various types of routines.

1054

---

What are system variables and sequencers in datastage

1182

---

What is the difference between in process and inter process?

1203

---

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

---

Explain ibm infosphere information server and highlight its main features?

1140

---

How a routine is called in datastage job?

1163

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2281

---

Difference between server jobs & parallel jobs?

1131

---

What is datastage engine?

1225

---

Why fact table is in normal form?

1310

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3523

---

What are the functionalities of link partitioner?

1067

---

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

2410

---