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.

How to perform incremental load in datastage?

0 Answers  

---

Which commands are used to import and export the datastage jobs?

0 Answers  

---

what is repositery?

0 Answers   IBM,

---

how to define satge variables in transformer stage

2 Answers  

---

In merge stage can we update the values?

3 Answers   TCS,

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---

what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,

---

How do you run datastage job from the command line?

0 Answers  

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

0 Answers  

---

1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?

0 Answers   EDS,

---

What is the difference between SQl Loader and OCI in datastage?

2 Answers   CSC,

---

How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  

---