How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
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
Differentiate between hash file and sequential file?
What is the difference between operational data stage (ods) and data warehouse?
What is apt_config in datastage?
Why fact table is in normal form?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How do you import and export the datastage jobs?
Whats difference betweeen operational data stage (ods) and data warehouse?
What are the steps required to kill the job in Datastage?
Difference between server jobs & parallel jobs?
If you want to use the same piece of code in different jobs, how will you achieve it?
Differentiate between Join, Merge and Lookup stage?
what is ds administrator used for?
Difference between data warehousing and olap?
project Steps,hits, Project level HArd things,Solved methods?
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 ?