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 surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?

5 Answers   SLK Software,

---

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,

---

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,

---

what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers   IBM,

---

I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,

---

Explain the situation where you have applied SCD in your project?

0 Answers  

---

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.

0 Answers   JPMorgan Chase,

---

how to find no.of records in sequntial file itself?

4 Answers  

---

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

0 Answers   EDS,

---

What is the difference between validated and compiled in the datastage?

0 Answers  

---

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,

---

what r the stages mostly used in realtime scenarios

4 Answers   HCL, IBM,

---