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.

How do you generate sequence number in datastage?

0 Answers  

---

sed,awk,head

0 Answers   CTS,

---

what are fact tables and dimension tables? give example assuming one table.

3 Answers   IBM,

---

how to design the change capture stage in(data stage parallel jobs) type 2

2 Answers   IBM,

---

Can you implement SCD2 using join, transformer and funnel stage?

0 Answers   Cognizant,

---

how can we join one oracle & flat files ?

2 Answers   ME,

---

What is Fastly Changing Dimension?

6 Answers   TCS,

---

Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

3 Answers   TCS,

---

Highlight the main features of datastage?

0 Answers  

---

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers   TCS,

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

0 Answers  

---

Please tell me What is difference between 8.0 and 8.1

1 Answers   IBM,

---