Answer Posted / subbuchamala

File1,File2====Funnel-----Copy=======1st link AGG, 2nd link JOIN----Filter----OutputFile
1. pass the 2 files to funnel stage and then copy stage.
2. from copy stage 1st link to AGG stage, 2nd link to JOIN stage
3. In AGG stage, Group by Key column say ID, NAME take the count and JOIN based on KEY column
4. Filter on COUNT>1 send the output OutputFile
we get desired output

What steps should be taken to improve Datastage jobs?

1050

---

What a datastage macro?

1044

---

CHANGE CAPTURE

1292

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

992

---

Differentiate between hash file and sequential file?

1051

---

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 ?

2003

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1244

---

What are the types of containers?

1206

---

How to RD using transformer?

1405

---

Difference between in process and inter process?

1207

---

What can we do with datastage director?

1220

---

Differentiate between datastage and datastage tx?

1038

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3317

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2139

---

What are the types of hashed files in data stage

1097

---