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.

What is the default execution order of the sequential file?

3 Answers  

---

guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.

2 Answers   TCS,

---

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,

---

how can we extract data with out having any common column

7 Answers   IBM, Switch2iTech,

---

What are stage variables, derivations and constants?

0 Answers  

---

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

4 Answers   L&T,

---

What is a datastage job?

0 Answers  

---

I have a few records just I want to store data in to targets cycling way how?

0 Answers   Polaris,

---

What's the Main Function of the Staging area in DWH

3 Answers   Oracle,

---

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers   EDS,

---

How to manage date conversion in Datastage?

0 Answers  

---

how can we send even and odd records from a sequential file to two different targets

10 Answers   IBM, iGate, TCS,

---