Interested to Buy Any Domain ? << Click Here >> for more details...
How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
- 1 Answers
- 6813 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What is the roundrobin collector?
What are the types of jobs we have in datastage?
I have a few records just I want to store data in to targets cycling way how?
what is 'reconsideration error' and how can i respond to this error and how to debug this
how to add a new records into source?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Name the third party tools that can be used in datastage?
State the difference between an operational datastage and a data warehouse?
How many types of sorting methods are available in datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Define Job control?
What is process model?
What is the method of removing duplicates, without the remove duplicate stage?
