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.

whats relation between configuration file and datasets?

2 Answers   L&T, Wipro,

---

What are the steps needed to create a simple basic datastage job?

0 Answers  

---

In Datastage, how you can fix the truncated data error?

0 Answers  

---

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,

---

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,

---

What is the difference b/w Hash file and Lookup Fileset stages?

1 Answers  

---

Define orabulk and bcp stages?

0 Answers  

---

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

What is the use of hoursfromtime() function in transformer stage in datastage?

0 Answers  

---

What is APT_DUMP_SCORE?

2 Answers   IBM,

---

How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers  

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

0 Answers  

---