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
What are the different kinds of views available in a datastage director?
What is the difference between odbc and drs stage?
Difference between in process and inter process?
Why do you need stage variables?
Does datastage support slowly changing dimensions ?
How many types of hash files are there?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What are the features of datastage flow designer?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Define Data Stage?
Notification Activity
Differentiate between odbc and drs stage?
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
What are routines in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?