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.

In which situations we can use normal and sparse lookup stages

4 Answers   IBM,

---

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,

---

How can we run same job in 1 day 2 times

4 Answers   IBM,

---

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

---

i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?

4 Answers  

---

Which algorithm you used for your hashfile?

0 Answers  

---

Can you explain link buffering?

0 Answers  

---

Main Function of the Staging area in DWH ?

2 Answers  

---

How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,

---

Define orabulk and bcp stages?

0 Answers  

---

What are the job parameters?

0 Answers  

---

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

---