Answer Posted / kanakam

hi guys for this scenario we need to do the following steps

1.First take the two sequential file stages
2.Use the Join stage,in join stage use the fullouter join
3.Take the Filter stage in filter stage we have to write
the where clause conditions:
a.for getting the Output1:Right.columnname=''
b.For gettting the output2:Right.columnname=left.columnname
c.for getting output3:Left.columnname=''

Can you explain link buffering?

1222

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1272

---

What are the benefits of datastage?

1301

---

What are the different options associated with dsjob command?

1484

---

Can we use target hash file as a lookup ?

3373

---

What is difference between join, merge and lookup stage?

1150

---

Lookup constraints

1307

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

969

---

Have you have ever worked in unix environment and why it is useful in datastage?

1183

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2665

---

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.

3403

---

What is difference between server jobs & parallel jobs?

1089

---

What is the method of removing duplicates, without the remove duplicate stage?

1079

---

what is ds administrator used for?

1219

---

how to write server Routine coding?

2181

---