Answer / niti

data should be hash partitioned & sorted.. :)

Answer / shar

1.Inputs as left right and intermediate links(files).
2.can do left outer,right outer,inner join and full outer join
3.N inputs for left,right and inner but 2 inputs for full outer.
4.Inputs should be sorted and partitioned for better
performance.
5.Removing duplicates is optional as join operation is
highly optimized which sequential and less i/o and less page
faults.
6.Memory requirements are comparatively less than Lookup stage.
7.In join key columns names should be same in primary and
secondary datasets.

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

9 Answers   Patni,

---

What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?

1 Answers  

---

To see hidden files in LINIX?

0 Answers   CTS,

---

Difference between sequential file and data set?

0 Answers  

---

What is mapping?

3 Answers  

---

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers  

---

What is active and passive stage?

0 Answers  

---

Can aggregator and transformer stages use to sort the data? How ?

2 Answers  

---

what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,

---

How many types of sorting methods are available in datastage?

0 Answers  

---

What is a merge in datastage?

0 Answers  

---

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

---