Answer / subbuchamala

by setting below option in MERGE stage, we can log 'unmatched Master' records and 'Reject Updates' in log files:

1. Warn on Rejected Updates=TRUE
--->True to generate a warning when bad records from any update links are rejected.
2. Warn on Unmatched Masters=TRUE.
--->True to generate a warning when there are unmatched rows from the master link.

which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

2 Answers   TIAA CREF,

---

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

---

If you want to use a same piece of code in different jobs, how will you achieve this?

0 Answers  

---

what are the errors,warnings in datastage

0 Answers   Syntel, Wipro,

---

Difference between in process and inter process?

0 Answers  

---

---

A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise

3 Answers   Polaris,

---

how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,

---

How we can covert server job to a parallel job?

0 Answers  

---

How many areas for files does datastage have?

0 Answers  

---

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,

---

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  

---