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.

ename like ibm,tcs,hcl need display those records only how?

2 Answers  

---

which memory is used by lookup and join

5 Answers   IBM,

---

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000

2 Answers   HCL,

---

what is the use of surogate key in datastage

3 Answers  

---

How we can convert rows to columns in datastage?

4 Answers   IBM,

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

5 Answers   IBM,

---

What are sequencers?

0 Answers  

---

Why do we use link partitioner and link collector in datastage?

0 Answers  

---

one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?

8 Answers   IBM,

---

How to delete the data in dataset?types of deleting the data in dataset?

4 Answers   HSBC,

---

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers   ME,

---

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,

---