Answer / rajesh pandi

1.if a source have huge volume of datea, then that time we have to use join, or merge stage
2.if you want to filter the unmatched record from reference files, then we should use merge stage only
3.join stage can have 'n' number of input link(1 left link 1right link other links called intermediate link) but only one output link...
Merge stage cane have 'n' no of input link (1 master link n update link) and one output link And equal no of reject link as same as update link
Look up stage can have n number of input link and 1 output link and one reject link
4.join we can do all join operation inner, left outer, right outer, full outer but in merge and lookup we can only do a inner join and left outer join

Answer / rajesh pandi

1.if a source have huge volume of datea, then that time we have to use join, or merge stage
2.if you want to filter the unmatched record from reference files, then we should use merge stage only
3.join stage can have 'n' number of input link(1 left link 1right link other links called intermediate link) but only one output link...
Merge stage cane have 'n' no of input link (1 master link n update link) and one output link And equal no of reject link as same as update link
Look up stage can have n number of input link and 1 output link and one reject link
4.join we can do all join operation inner, left outer, right outer, full outer but in merge and lookup we can only do a inner join and left outer join

How can we improve the performance in datastage?

0 Answers  

---

what is materialized view used datastage?

1 Answers   HSBC,

---

how can we create tables in datastage?

1 Answers  

---

what is parameterset?

4 Answers   Wipro,

---

how to closeing records after 10,000 records come?

3 Answers  

---

I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,

---

What all are the different way to run a job?

0 Answers  

---

I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

1 Answers   Amdocs, TCS,

---

1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

2 Answers   Mind Tree,

---

what is the use of invokation id

2 Answers   IBM,

---

How many types of sorting methods are available in datastage?

0 Answers  

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

0 Answers  

---