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.

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1385

---

What is the sortmerge collector?

1138

---

How can we improve performance of data stage jobs?

1019

---

Could anyone give brief explanation bout datastage admin

2362

---

How do you import and export data into datastage?

1243

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2471

---

On which Dimension Table you implemented SCD Type in your Project

2059

---

What is active and passive stage?

1419

---

How many types of views are there in a datastage director?

1297

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2027

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

811

---

What are the types of hashed files in data stage

1110

---

What are the primary usages of datastage tool?

1075

---

what are the errors,warnings in datastage

2706

---

What are the features of datastage flow designer?

1044

---